Using percentages

G

GENO

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)
 
J

Jacob Skaria

Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=AVERAGE(IF(I7:I16<>0,I7:I16))

If this post helps click Yes
 
B

Brad

Jacob Skaria formula will work

Here is another one
=SUM(D2:D6)/COUNTIF(D2:D6,">0")

This is not an array formula and assumes that all numbers will be 0 or
greater.
 
J

Jacob Skaria

Brad, provided you do not have negative values in the range...In this case.Yes

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top