This is probably a really basic question, but I'm relatively new to Excel so here goes:
I have one sheet that contains all of my formulas and other sheets that contain the data. I am trying to write a formula on my 'Formulas' sheet that counts how many cells say CPT or 1LT the following range -- C4:C20 on a sheet titled '2 MED Personnel'
This range contains LTC, MAJ, CPT, and 1LT.
Thanks for any help you can provide.
Patrick
Bookmarks