Bob Phillips
12/12/2006 9:42:00 AM
=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" <PGOriel@discussions.microsoft.com> wrote in message
news:CCC11F55-F61C-4406-B676-408C914D18EE@microsoft.com...
> 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