Sumif with dates for range criteria

  • Thread starter Thread starter Chad Linders
  • Start date Start date
C

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
 
Change your formula to put the cell reference outside of the quotation
marks:

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