sum cells that meet a specific condition

  • Thread starter Thread starter George P
  • Start date Start date
G

George P

very simple. don't know why i can't get it. sum numbers (values are in
rows) whose relative date (dates in rows) is less than or equal to today
(now()). that's the only qualifier.

i've tried sumproduct, sumif, dsum...

i'm stumped.

George
 
Try this:

A1:E1 = dates with no empty cells
A2:E2 = numbers to sum

=SUMIF(A1:E1,"<="&TODAY(),A2:E2)
 
Back
Top