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