I'm having trouble with using sumproduct on values between certain dates in order to give a weighted average price.
I have a column of dates (Column A), a column of volumes Column B), and a column of prices (Column C). I need to find the sumproduct of the volumes and prices between the specified dates in order to calculate a weighted average price. Right now, all I can do is take the sum product of the entire volumes and price columns and simply add in the volumes I want get the W.A.P. on and delete the volumes I no longer need. I would like to have all of the volumes on there and use sumproduct between certain dates so I can get multiples W.A.Ps at once without having to add them in manually one by one.
All of the examples I have seen on here only seem to deal with two total columns so any help with this would be greatly appreciated.
Bookmarks