Calc Percentage of multi cells (Array)

[eyepods]

Hi All. I am struggling to understand which formula to use when try to calc total pecentage from a array. I have a list of 16 results (number values between 0-6) and wish to calc a total percentage for all 16 values.? (ignoring '0' values).
example values: 1,3,5,3,5,6,2,6,2,1,0,6,4,3,5,6,
I assumed I could simply use PERCENTAGE formula to get the total percentage but oh no.... I look at several treads that suggested using other formula (i.e=COUNTIF) but still no joy.... Can anyone help or identify the best option.... Thanks

currently using a basic formula =SUM(C39:R39)*16/12

 

[NARAYANK991]

Hi ,

Will this not work ?

=SUM(C39:R39)/COUNTIF(C39:R39,"<>0")

For the data you have posted , what is the expected output ?

Narayan

 

[bosco_yip]

I think the percentage is :

=SUM(C39:R39)/COUNTIF(C39:R39,"<>0")/6

Remark: each cell max. value is 6 as stated by the O.P. "a list of 16 results (number values between 0-6)"

The result is 64.44% (Cell format >> Percentage)

Regards
Bosco

 

[eyepods]

Hi Narayan/Bosco.
Many thanks for your help, appreciated. The formula indicated worked.! I made a small change to the COUNTIF statement to allow for '0' values (">=0) as the above returned a #DIV/0! if all values = 0: =SUM(C39:R39)/COUNTIF(C39:R39,">=0")/6

Many thanks again.
Mike