Adding percentages >0

C

Caractus

Hi all.

I have a sheet where H15:H71 are filled with percentages.

What I'd like is to calculate the whole area above without counting any
cells containing zero.

Can anyone help please?
 
P

Pete_UK

Do you mean you want to count the cells which are not equal to zero, or
add them up? Try one of these:

=COUNTIF(H15:H71,"<>"&0)

=SUMIF(H15:H71,"<>"&0,H15:H71)

Hope this helps.

Pete
 
C

Caractus

I want to count the cells which are not equal to zero but the thing is
they're all percentages so an average would probably be more accurate,
otherwise the total will read as over 100%
 
C

Caractus

Thanks for the reply Pete.

I want to count the cells which are not equal to zero but they are all
percentages, so an average would probably be more accurate. Otherwise
the total would be over 100%.
 
B

Bob Phillips

=AVERAGE(IF(H15:H71<>0,H15:H71))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Top