I hope Otavia gave you SUMPRODUCT not SUM for the formula you show
This should work
=SUMPRODUCT((D10:D20<TODAY())*(A10:A20)
or this
=SUMIF(D10:D20,"<"&TODAY(),A10:A20)
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP
"tleehh" wrote in message
...
using given formula by Otavio sum((B10:B20="s1")*(C10:C20<"x")*A10:A20),
how can it add all the values in colume A that is prior to todays date
(dates
are in colume D).