Using percentages
 

I am using percentages to calculate a score of 1 - 5 which updates a
dashboard. I have an average of multiple scores adding up to 100% or less. I
would like to make an input of 0 to remove this column from the average of
other scores.

example " =average(i7:i16)" if "i8" input is "0", remove "i8" from average
"=average(i7,i9:i16)"...

Any suggestions, (thanking you in advance)

Using percentages
 

Use your formula like this...

=SUM($I$7:$I$16)/(COUNT($I$7:$I$16)-COUNTIF($I$7:$I$16,0))

Just change the cell reference to your desired cell if required.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"GENO" wrote:

I am using percentages to calculate a score of 1 - 5 which updates a
dashboard. I have an average of multiple scores adding up to 100% or less. I
would like to make an input of 0 to remove this column from the average of
other scores.

example " =average(i7:i16)" if "i8" input is "0", remove "i8" from average
"=average(i7,i9:i16)"...

Any suggestions, (thanking you in advance)