Hi,

I have been using the following formula to get a weighted average when using autofilter. However, now I have some new data in column Z that contains blank cells. My formula is counting the blank cells as zero. Therefore, my weighted average is coming back as 28; however, when I use the autofilter to disgard (NonBlanks), the weighted average is 96. I want to be able to get the proper weighted average by having the formula ignore the blank cells in column Z. How would I do that with this array formula? Is it possible?

{=SUM(SUBTOTAL(9,OFFSET($D$3,ROW(INDIRECT("1:100")),0))*SUBTOTAL(9,OFFSET(Z3,ROW(INDIRECT("1:100")),0)))/SUBTOTAL(9,$D$3:$D$96)}