How do I create a formula to add values from specific fields?

C

cabodiamonds

Example, from a list of several buyers who place orders on a regular basis, I
want to know how to write the formula in another table that adds the daily
inputs and totals it for the specific month, for a particular buyer. So if I
input the purchases of the day for 12 different buyers, if I want to check
what a particular buyer has bought for the month, it will be in another
table, but only the total to-date.

Greg
 
B

Biff

Hi!

You need to provide more detail.

Here's my best guess at what you want:

Column A = dates
Column B = buyers
Column C = totals

To sum the totals for a specific buyer for a specific
month:

=SUMPRODUCT(--(ISNUMBER(A1:A100)),--(MONTH(A1:A100)=1),--
(B1:B100="buyer"),C1:C100)

For a YTD total:

=SUMPRODUCT(--(ISNUMBER(A1:A100)),--(YEAR(A1:A100)=2004),--
(B1:B100="buyer"),C1:C100)

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a formula to add values from specific fields? 1
Trying to count the number of buyers or sellers for a given month. 4
Crating User Form to Add Names 1
Locking a Spreadsheet but allow inserting 5
Macro to Select text from a point given to a specific word 2
Creating a Search using a combo box and then creating a report. 4
Excel PRICE function: How does it compute Issue Date of the Security 5
How to correct a #N/A in vlookup 1

Top