View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kweenie Kweenie is offline
external usenet poster
 
Posts: 12
Default Don't COUNT 0%??

=Countif(C1:C3;"<0%")

Regards

Piet


PG Oriel schreef:


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