Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2005
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count IF Function (Excel 2000)

    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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count IF Function (Excel 2000)

    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:A 21,"Cpl")+COUNTIF(Roster!A2:A21,"Sgt")+COUNTIF(Ros ter!A2:A21,"SSgt")+COUNTIF(Roster!A2:A21,"GySgt")+ COUNTIF(Roster!A2:A21,"MSgt")+COUNTIF(Roster!A2:A2 1,"MGySgt")

  3. #3
    New Lounger
    Join Date
    Mar 2005
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count IF Function (Excel 2000)

    Thanks just what I needed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •