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)

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
---------------
Jacob Skaria


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

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.
--
Wag more, bark less


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

=SUM(D2:D6)/COUNTIF(D2:D6,"0")
should be
=SUM(I7:I16)/COUNTIF(I7:I16,"0")
--
Wag more, bark less


"Brad" wrote:

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.
--
Wag more, bark less


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

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

If this post helps click Yes
---------------
Jacob Skaria


"Brad" wrote:

=SUM(D2:D6)/COUNTIF(D2:D6,"0")
should be
=SUM(I7:I16)/COUNTIF(I7:I16,"0")
--
Wag more, bark less


"Brad" wrote:

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.
--
Wag more, bark less


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