sum cells that meet a specific condition
 

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

sum cells that meet a specific condition
 

Try this:

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

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

--
Biff
Microsoft Excel MVP


"George P" wrote in message
...
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