Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it possible to use the #N/A error as criteria when using SUMIF?
I'm thinking of something along the lines of =SUMIF(B3:B32,ISNA(C3:C32)), either entered as an array formula or as a conventional formula, however, I keep getting 0 returned. The value should be greater than 0. (And, yes, the #N/A values in C3:C32 are logical values returned as the result of a formula; they are not hard-coded in.) Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumif with 2 criteria | Excel Discussion (Misc queries) | |||
SUMIF with two criteria?? | Excel Discussion (Misc queries) | |||
SUMIF with 2 criteria PLEASE HELP | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
Criteria with "<" or ">" in sumif() | Excel Discussion (Misc queries) |