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~~~

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

Whe
A2:A21 is a list of dates
E4 is the 'FROM' date
E5 is the 'TO' date
B2:B21 is a list of prices
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Ezzat" wrote:

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~~~

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?

"Gary Brown" wrote:

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

Whe
A2:A21 is a list of dates
E4 is the 'FROM' date
E5 is the 'TO' date
B2:B21 is a list of prices
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Ezzat" wrote:

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~~~