Sum of Price Given Specific Dates
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~~~
|