| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF <
Hi everyone,
Someone wrote this function in a workbook that I am asked to describe: SUMIF($K94:$R94;"<";$K$9:$R$9) And it actually yields 2! I can understand SUMIF if the criteria part is something like "3" or "67" - but how should I interpret "<"? What does it mean? Thank you, Cooz |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF <
It means not blank.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cooz" wrote in message ... Hi everyone, Someone wrote this function in a workbook that I am asked to describe: SUMIF($K94:$R94;"<";$K$9:$R$9) And it actually yields 2! I can understand SUMIF if the criteria part is something like "3" or "67" - but how should I interpret "<"? What does it mean? Thank you, Cooz |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF <
Hi Bob,
Not blank makes perfect sense. Thank you. Cooz "Bob Phillips" wrote: It means not blank. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Cooz" wrote in message ... Hi everyone, Someone wrote this function in a workbook that I am asked to describe: SUMIF($K94:$R94;"<";$K$9:$R$9) And it actually yields 2! I can understand SUMIF if the criteria part is something like "3" or "67" - but how should I interpret "<"? What does it mean? Thank you, Cooz |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF <
It means not equal
-- Gary''s Student - gsnu200764 "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: SUMIF($K94:$R94;"<";$K$9:$R$9) And it actually yields 2! I can understand SUMIF if the criteria part is something like "3" or "67" - but how should I interpret "<"? What does it mean? Thank you, Cooz |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF <
Hi Gary''s Student,
I should have mentioned that I knew that it meant "not equal". I wondered what it should not be equal to. Cooz "Gary''s Student" wrote: It means not equal -- Gary''s Student - gsnu200764 "Cooz" wrote: Hi everyone, Someone wrote this function in a workbook that I am asked to describe: SUMIF($K94:$R94;"<";$K$9:$R$9) And it actually yields 2! I can understand SUMIF if the criteria part is something like "3" or "67" - but how should I interpret "<"? What does it mean? Thank you, Cooz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| SUMIF | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Hybrid Mode
