Sumproduct and CountA combined? Is that possible?
Try this:
=SUMPRODUCT(--(A1:A10="June"),--(B1:B10=1),--(C1:C10=2009),--(D1:D10="Jim"),--(ISNUMBER(MATCH(F1:F10,category_range,0))))
--
Biff
Microsoft Excel MVP
"wx4usa" wrote in message
...
Can I combine Sumproduct and CountA somehow?
I have a list of categories that I use for a Sumproduct formula.
The list is segregated by employee, month, day and year. I also would
like to have a total of all categories for an employee.
Here are my columns
A=month B=day C=year D=employee F=category
Is there a way to do this...
=sumproduct((month="June")*(day=1)*(year=2009)*(em ployee="Jim")*counta
(category))
|