Sumif with dates for range criteria

[Chad Linders]

I would like to sum values in a column if values/dates in
a respective column are "less than" current date. When I
enter the following, I do not get an error, but I get "-"
for a sum:

=sumif(a1:a12,"<b20",b1:b12)

where cell b20 has current date.

Any help would be appreciated.

Thanks,
Chad

 

[Debra Dalgleish]

Change your formula to put the cell reference outside of the quotation
marks:

=SUMIF(A1:A12,"<"&B20,B1:B12)

 

[Alan Beban]

Try

=SUMIF(A1:A12,"<"&B20,B1:B12)

Alan Beban