--(MONTH(Master!Y3:Y714)=10)
--
Regards,
Peo Sjoblom
"rhouchins" wrote
in message ...
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"),--(ISNUMB
ER(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
--
rhouchins
------------------------------------------------------------------------
rhouchins's Profile:
http://www.excelforum.com/member.php...o&userid=28475
View this thread: http://www.excelforum.com/showthread...hreadid=480839