Forum Discussion
Average and Percentage Help
Hello, I know how to do an average function, but I am having a hard time doing the average if the variables changes. So what I have is 3 aisles that I rate on a scale of 0-3s or N/A with 3 being per...
Given your perfect score of 24, the score should be calculated like this to return 24 and to result in a percentage of 100%:
=AVERAGEIF(Aisle1:Aisle3,
">=0")*8