Thread: SUMIF <
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cooz Cooz is offline
external usenet poster
 
Posts: 24
Default 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