Don't COUNT 0%??
 

=COUNT(IF(A1:A10<0,A1:A10))

which is an array formula, so commit with Ctrl-Shift-Enter, not just Enter.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"PG Oriel" wrote in message
...
Hi,

I want to count a selection of cells, but do not want to include 0%. I
have
tried to do countif and use the criteria 0 but this causes an error. Any
ideas?

Thanks