sumproduct
 

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


--
rhouchins
------------------------------------------------------------------------
rhouchins's Profile: http://www.excelforum.com/member.php...o&userid=28475
View this thread: http://www.excelforum.com/showthread...hreadid=480839

sumproduct
 

--(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