Need help with sumproduct formula

[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. Valko]

Is "8/11" a valid date?

Use cells to hold the criteria:

A1 = 8/11
A2 = west

=SUMPRODUCT(--(B2:B10=A1),--(D210=A2))