sumproduct

[rhouchins]

I am trying to use sumproduct to count three columns in a spreadsheet
and add them to see how many times those values are true.

=SUMPRODUCT(--(Master!G3:G1714="XXX"),--(Master!R3:R1714="YYYYYY"),--(ISNUMBER(FIND("-",Master!Y3:Y714))))

Column Y contains a date in the format of "12-Oct". What would be the
easiest way to account for cells that contain a date and incorporate it
as the third wheel of the formula?

Using the hypen(-) or "OCT" is returning a #VALUE error.

Thanks

 

[Peo Sjoblom]

--(MONTH(Master!Y3:Y714)=10)