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