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 |
#2
|
|||
|
|||
If your arrays are identically sized, I'd suspect that you have the #N/A
error in one or more of the referenced cells that SUMPRODUCT() is passing through. In article , schleppy2 wrote: 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 |
#3
|
|||
|
|||
"schleppy2" wrote
in message ... 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)) 1 - You can't get SUMPRODUCT() writing its result in a place different from the cell it is written in. 2 - You must have all parameters as Array I think you should write, being in SA (a single cell Named SA): =IF(AND(status="I",grade=O5),N6,"") Bruno |
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 |