ExcelBanter - Don't COUNT 0%??

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Don't COUNT 0%?? (https://www.excelbanter.com/excel-programming/379242-re-dont-count-0%25.html)

Kweenie

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

All times are GMT +1. The time now is 10:05 PM.