Thread: SUMIF <
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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