SUMIF using #N/A error as criteria

[Dave F]

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.

 

[T. Valko]

Try it like this:

=SUMIF(C3:C32,"#N/A",B3:B32)

 

[RagDyer]

These work:

=SUMIF(C3:C32,#N/A,B3:B32)

=SUMIF(C3:C32,NA(),B3:B32)

 

[PCLIVE]

One possible way:

=SUMPRODUCT(--(ISNA(C3:C32)),B3:B32)

HTH,
Paul