SUMIF <>

[Cooz]

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

 

[Bob Phillips]

It means not blank.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gary''s Student]

It means not equal

 

[Cooz]

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

 

[Cooz]

Hi Bob,

Not blank makes perfect sense.
Thank you.

Cooz