Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default 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.

please help me.

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

  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.

please help me.

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumif function in excel Basil Excel Worksheet Functions 5 January 3rd 17 07:39 AM
SUMIF Function Peter Curtis Excel Discussion (Misc queries) 2 January 12th 05 02:02 PM
how do you do a sumif function on more than one worksheet? BMWPRO Excel Worksheet Functions 1 December 6th 04 08:26 PM
using logical functions as criteria with the SUMIF function pfdubz Excel Worksheet Functions 6 December 1st 04 07:40 PM
Can I use a cell reference in the criteria for the sumif function. Number Cruncher Excel Worksheet Functions 2 November 4th 04 07:52 PM


All times are GMT +1. The time now is 02:14 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"