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))

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))