• Count IF Function (Excel 2000)

    Author
    Topic
    #416651

    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

    Viewing 0 reply threads
    Author
    Replies
    • #932593

      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”)

    Viewing 0 reply threads
    Reply To: Reply #932596 in Count IF Function (Excel 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel