Remember Me?

#1
 Posts: n/a
help with "criterea" in the sumif function

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.

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

#2
 Frank Kabel Posts: n/a

#3
 Peo Sjoblom Posts: n/a

Use

=COUNTBLANK(Range1)

to count blank cells, to count numbers

=SUMPRODUCT(--(ISNUMBER(Range1)))

to sum another range where the first range is blank

=SUMPRODUCT(--(ISBLANK(Range1)),Range2)

to sum another range where the first range is a number

=SUMPRODUCT(--(ISNUMBER(Range)),Range2)

Regards,

Peo Sjoblom

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

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

#4
 Posts: n/a

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Basil Excel Worksheet Functions 5 January 3rd 17 08:39 AM Peter Curtis Excel Discussion (Misc queries) 2 January 12th 05 03:02 PM BMWPRO Excel Worksheet Functions 1 December 6th 04 09:26 PM pfdubz Excel Worksheet Functions 6 December 1st 04 08:40 PM Number Cruncher Excel Worksheet Functions 2 November 4th 04 08:52 PM

All times are GMT +1. The time now is 06:36 AM.