Weighted Average with NA

[z10nv1ru5]

Hi,

My question is, what will be the formula and how to compute the weighted average if there will be a NA. On the attached sheet, If you type in "NA" on one of the column H (Actual), the SUM of K21 should not be affected.

I think there's a better way on doing this, but I'm really stucked. Thanks for the help

[majosum]

It looks like it is working fine. What exactly is the problem in the sheet you uploaded?