How do I add multiple values that match multiple conditions?
Thanks Toppers, I must be locked into counting today.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Toppers" wrote in message
...
Bob,
A typo plus missing data but for me another lesson on comparing
dates (--"2005-01-24"):
=SUMPRODUCT(--(A2:A20=--"2005-01-24"),--(B2:B20="Joel"),--(C2:C20))
"Bob Phillips" wrote:
=SUMPRODUCT(--(A2:A20=--"2005-01024"),--(B2:B20="Joel"))
You could also put the values in cells and test against those.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Joel" wrote in message
...
I have been trying to do this forever. I am using this for sales
metrics,
and reporting. Here is the data
Date Rep Revenue Service
01-24-2005 Joel $20 $5
01-24-2005 Bob $22 $7
01-24-2005 Joel $14 $3
01-25-2005 Joel $27 $10
01-25-2005 Joel $22 $11
Ok what I want to do is sum up how much Joel sold on 01-24-2005 ($34),
So
the conditions are Joel, and the date. How would you add that up
without
adding Bob's numbers in there?
|