adding/omitting/all the values prior to todays date
 

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).

adding/omitting/all the values prior to todays date
 

"tleehh" wrote:
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).

=SUMPRODUCT((B10:B20="s1")*(C10:C20<"x")*(D10:D20 <TODAY()), A10:A20)

Or do you mean simply:

=SUMPRODUCT(--(D10:D20<TODAY()), A10:A20)

or alternatively:

=SUMIF(D10:D20, "<" & TODAY(), A10:A20)

adding/omitting/all the values prior to todays date
 

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).