Calculating Weighted Average excluding blanks
I am attempting to calculate scores from satisfaction surveys. The issue is if someone leaves one of the three questions blank, excel turns that answer to a zero, throwing off the data.
Is there a formula for "non percentage" values to calculate weighted average without including the blank boxes?
|