|
How do I count these?
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 - |
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 - |
| All times are GMT +1. The time now is 07:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com