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

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

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

-----Original Message-----
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
.