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

Caractus wrote:

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?