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

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

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

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

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