View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default Using percentages

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)