One way

=COUNTIF(B2:B500,"0")

Regards,

Peo Sjoblom

"TNMAN" wrote:

I have a spreadsheet with column A with five row descriptions beginning with
cell A1. In columns B through D I have information. I need to be able to
count the provider with gross charges greater than o in each column. Thanks
in Advance for your help.

Provider - Salazar
Gross charges
- -
Net
- - -
Net Collections 786,038 #DIV/0! #DIV/0!
Estimated encounters per
- - -
Days worked per
- - -

Provider - Byrer
Gross charges
- -
Net
- - -
Net Collections 21,696 #DIV/0! #DIV/0!
Estimated encounters per
- - -
Days worked per
- - -

Provider - Butler
Gross charges 73250
Net charges
Net Collections 42,399 #DIV/0! #DIV/0!
Estimated encounters per year
Days worked per year

Provider - Williamson
Gross charges 545597.09
Net charges
Net Collections 315,809 #DIV/0! #DIV/0!
Estimated encounters per year
Days worked per year

Provider - Wood
Gross charges 231000.9
Net charges
Net Collections 133,711 #DIV/0! #DIV/0!
Estimated encounters per year
Days worked per year

Summary (all providers)
Gross charges
- -
Net
- - -
Net Collections 1,299,653 #DIV/0! #DIV/0!
Estimated encounters per
- - -
Days worked per
- - -
Number of Providers -