See image below, I think it's clear. I want the formula I need to put into cell H2 (green highlight) to generate the weighted average (of rows that meet a certain criteria -- in this case AAPL stock). I then want to be able to copy the formula down (to cells H3:H5) so it calculates the same for all stocks.
I know that SUMPRODUCT would do the trick if the source table consisted of ONLY rows of AAPL stock (like i show in the RED cells), but my table is large with hundreds of symbols. Seems like I need some combo of SUMPRODUCT and SUMIF...maybe a SUMPRODUCTIF, but that doesn't exist...
I know that SUMPRODUCT would do the trick if the source table consisted of ONLY rows of AAPL stock (like i show in the RED cells), but my table is large with hundreds of symbols. Seems like I need some combo of SUMPRODUCT and SUMIF...maybe a SUMPRODUCTIF, but that doesn't exist...
Last edited: