Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Average excluding blank cells

Dear all,   We are running an Employee Satisfaction Survey in our company but I am having hard time to find the average scores due to the blank cells in data cells, therefore looking for your valua...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    You just have a precedence issue (order of operations)

     

    Leadership index Correct = (AVERAGE(Table10[Question 1])+AVERAGE(Table10[Question 2]))/2
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
7 years ago

You just have a precedence issue (order of operations)

 

Leadership index Correct = (AVERAGE(Table10[Question 1])+AVERAGE(Table10[Question 2]))/2