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