Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sumproduct resulting in #N/A
guys and gals, little help.. I am working in a spreadsheet that has 22,000 records and I am trying to get a total for 3 different criteria. So I am using the sumproduct which looks like this: =SUMPRODUCT(--(status="I"),--(grade=O5),--(SA=N6)) status being constant and grade and sa being my variables. It keeps returning a #N/A. my ranges are identically sized and formats should not matter. Would it have something to do with the fact that I am querying 22000 records. This is due by days end.. any help, would be greatly appreciated. Thanks Schlep -- schleppy2 ------------------------------------------------------------------------ schleppy2's Profile: http://www.excelforum.com/member.php...o&userid=27013 View this thread: http://www.excelforum.com/showthread...hreadid=471372 |
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 |