SUMIF function doesn't work with "date less than" cell reference

  • Thread starter Thread starter Anil
  • Start date Start date
A

Anil

SUMIF function doesn't work with "less than" cell
reference which contains a date
eg sumif(A1:A10,<c1,B1:B10)
it returns a zero value
I tried with using value(c1), then it adds all the amounts
 
Anil said:
SUMIF function doesn't work with "less than" cell
reference which contains a date
eg sumif(A1:A10,<c1,B1:B10)
it returns a zero value
I tried with using value(c1), then it adds all the amounts
Click to expand...

The correct syntax is
=SUMIF(A1:A10,"<"&C1,B1:B10)
 
Back
Top