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

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
 
A

Anon

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF with criteria "<>" & "=" 4
Calculate average in intervals 1
How do I use countif like sumif ie (range,criteria,count_range) 1
get a cell reference as a result of an If Function 1
Dsum and Dmax with structured references 1
Sumif using Arrays 2
Show value from one cell in another cell if today falls between a date range 5

Top