Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumif function in excel | Excel Worksheet Functions | |||
SUMIF Function | Excel Discussion (Misc queries) | |||
how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions | |||
using logical functions as criteria with the SUMIF function | Excel Worksheet Functions | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |