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