Sumproduct and CountA combined? Is that possible?

[wx4usa]

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)*(employee="Jim")*counta
(category))

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A1:A10="June"),--(B1:B10=1),--(C1:C10=2009),--(D110="Jim"),--(ISNUMBER(MATCH(F1:F10,category_range,0))))