Sumproduct and CountA combined? Is that possible?

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

T. Valko

Try this:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT Question Adding Hours? 1
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Date Format and Sumproduct 9
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Creating a Search using a combo box and then creating a report. 4
YEARLY TOTAL 1
Formula to locate all jobs in Month then break up into categories 4
SUMPRODUCT with date range running slow 1

Top