I will try.
The sample workbook has two lines of a medical clinic's providers schedules. The last 3 columns are the ones I want to use the formula in. In the 1st or "AM" column there I want to see the number of times the letter c appears in the "AM" column for each provider. For example, in cell AA3, I want to see how many times the "C" appears in cells C3,F3,I3,L3,O3,R3,U3, AND X3. In cell AB3, I want to see how many times the "C" appears in cells D3,G3,J3,M3,P3,S3,V3, AND Y3, etc.
I hope I have explained this well enough and that I attached the workbook correctly.
Brian
Bookmarks