E Ezzat May 7, 2009 #1 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~~~
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~~~
G Gary Brown May 7, 2009 #2 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
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
E Ezzat May 7, 2009 #3 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?
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?
