Re: Contiguous Weighted Average Excluding Zeroes
Sorry, I forgot to add in that the rows in between aren't actually blank, I meant to say that the rows with values will be subtotals. I've already got a method to filter out the intermediate rows (sumproduct, A:A, B:B, C:C)/(Sumproduct, B:B, C:C) where C has 1s and 0's that cancel out the 0 values in B
If I use that method again it will throw off the grand total, so I was wondering if there was a way to model the formula that I mentioned above.