Sum of Price Given Specific Dates

[Ezzat]

I have a column of dates, and another filled with price. How can I sum up the
prices for anything BEFORE a specific date? Help~~~

 

[Gary Brown]

Use SumProduct.
Example...
=SUMPRODUCT(--($A$2:$A$21>=E4),--($A$2:$A$21<=E5),--(B2:B21))

Where:
A2:A21 is a list of dates
E4 is the 'FROM' date
E5 is the 'TO' date
B2:B21 is a list of prices

 

[Ezzat]

Hi Gary, thanks for the reply. I tried the formula, but came up with a
"#VALUE!".

My dates are in column AD (AD2:AD109)
My Prices are in column I (I2:I109)
I need the sum of prices between:

1/1/07 (located at AI48). Number value is 39083.
and
5/31/09 (located at AI49). Number value is 39964.

Here is your formula after it's been plugged in.

=SUMPRODUCT(--(AD2:AD109>=AI48),--(AD2:AD109<=AI49),--(I2:I109))

Where did I go wrong?