Count statement to ignore £0.00 entries

[Ian_A85]

I need to know, is it possible to count the amount of entries in a column, but ignoring all cells that have £0.00 entered in to them.

Im currently using a large sheet in which it has many columns of costs adding into column AH. What I plan to to is count all the cells in AH, but exclude all costs of £0.00.

Can you help?

 

[Richard Schollar]

Hi

Try:

=COUNTIF(Ah:AH,">0")

 

[Ian_A85]

Hi Richard,

Thanks for that, it works like a dream!

Also, I cant beleive I didnt think of that before! God Bless MREXCEL!!