Need help with sumproduct formula

N

Nielly

I was given this formula =SUMPRODUCT(--(E2:E10="Dawn"),--(F2:F10="X"))
yesterday which worked perfectly. I tried to apply a "date" to one of
columns as a "name" but it does display the correct total.

I need to know how many times "8/11" in column B and "West" in column D are
in the same row.

Thank you in advance for your help.
 
T

T. Valko

Is "8/11" a valid date?

Use cells to hold the criteria:

A1 = 8/11
A2 = west

=SUMPRODUCT(--(B2:B10=A1),--(D2:D10=A2))
 

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

Top