SUMIF <>

  • Thread starter Thread starter Cooz
  • Start date Start date
C

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
 
It means not blank.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
 
Back
Top