Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |