Ok I have a huge workbook created. Each worksheet has a different client. Under each client there is a grid of the difference services and how many hours there are each day (for the quarter). That all sums up to the total hours at the end of the week. Now what I want to do is to perform a function that will count how many clients received a particular service in that quarter. I tried
=COUNTA(A:Z O21,">0.0")
=COUNT(A:Z O21,">0.0")
These are close but not totally up.
=SUMIF(A:Z O21,">0.0") That one was way wrong
I thought about doing a hidden formula but I send the form out to other agencies and I do not want to chance that because they do not see it, it gets changed. I guess worse comes to worse I could lock it. But it just seems to me that this can be done!
Bookmarks