OK I am not sure how to word the title, so I am sorry about that. I am going to attempt to explain what I am trying to do here. First off I have a table that tracks the soldiers I have at a particular location. The Table shows their Name and Rank in one cell, male or female in next cell, and what shift they are on in the last cell. I would like to be able to sum up the cells that contain criteria that I have listed in a seperate list on a seperate sheet. For example, my list of Criteria are the different ranks of soldiers we have. I would like to search each cell, compare the data to the list of ranks, and if that cell contains any of the data on that Criteria list then count it. I have to be able to do this across multiple ranges and then as I add and subject personnel. Having a little difficulty adding an example of what I need.
To try and sum it up, I need compare a cell to a range of ranks, if the cell contains that rank, count it..if not dont count it. The cell will look something like SPC Smith.
Please let me know if you need any further info to help.
Thanks a million!
Here is the list of Ranks:
RANKS
NCOS Soldiers Officers
CSM SPC LTC
SGM PFC MAJ
1SG PV2 CPT
MSG PVT 1LT
SFC 2LT
SSG WO1
SGT CW2
CPL CW2
CW3
and I want to compare those ranks to the below cells to see if they contain any of those ranks and then count them under each of the above categories (NCO, SOLDIER, OFFICER)
SGT Tippenhauer
SGT Echevarria
SPC Harris
PFC Barker
PFC McGrew
SGT Iaulualo
WO1 Brown
CW2 Whitley
1LT Palsgrove
CPT Simons
SGT Jayme
PFC Sadler
PFC Geniesse
PFC Hampton
SPC Burkhart
SSG Olsen
CW2 Sparger
Bookmarks