Need help with sumproduct formula
 

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.

Need help with sumproduct formula
 

Is "8/11" a valid date?

Use cells to hold the criteria:

A1 = 8/11
A2 = west

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

--
Biff
Microsoft Excel MVP


"Nielly" wrote in message
...
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.