Need help with sumproduct formula

  • Thread starter Thread starter Nielly
  • Start date Start date
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.
 
Is "8/11" a valid date?

Use cells to hold the criteria:

A1 = 8/11
A2 = west

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