Hi
you can't use these function with SUMIF. Try SUMPRODUCT instead. e.g.
=SUMPRODUCT(--(ISBLANK(A1:A100))

--
Regards
Frank Kabel
Frankfurt, Germany

wrote:
Hello folks,

I just may be tired but I can't seem to understand the various
implementations of criterea in the sumif function.

it seems that if i just set criterea to "" (detects blank cell)
or 35 ......(and 35 is in the criterea range).....I can get the
sumif to work.

I can't get the function to work if i use ISBLANK as teh criterea
or ISNUMBER as criterea.

i think what I am saying that i don't really appreciate the various
forms of criterea. i suspect i am not understanding something.

please help me.

bil
but if i set the criterea to be rc[-4]="" then the sumif functino
fails