Count IF Function (Excel 2000)

Topic

New Reply

I am currently working with a sheet that has information about employees collum A is rank or title, B LName, C FName…..
On a different sheet in the same workbook I am trying to enter a countIF function into one cell to add up all the Employee
Entries based on rank
The att. file is how It is currently set up.

Thanx

Reply | Quote

Replies

Try these formulas:

=COUNTIF(Roster!A2:A21,”2nd Lt”)+COUNTIF(Roster!A2:A21,”1st Lt.”)+COUNTIF(Roster!A2:A21,”Capt”)+COUNTIF(Roster!A2:A21,”Maj”)+COUNTIF(Roster!A2:A21,”LtCol”)

=COUNTIF(Roster!A2:A21,”LCpl”)+COUNTIF(Roster!A2:A21,”Cpl”)+COUNTIF(Roster!A2:A21,”Sgt”)+COUNTIF(Roster!A2:A21,”SSgt”)+COUNTIF(Roster!A2:A21,”GySgt”)+COUNTIF(Roster!A2:A21,”MSgt”)+COUNTIF(Roster!A2:A21,”MGySgt”)

Reply | Quote

Thanks just what I needed.

Reply | Quote