11 Replies Latest reply: Aug 8, 2016 10:20 AM by Alluraiah Allu RSS

    Need help on How to use count ?

    Animesh Achal

      Hello Everyone,

      I need one assistance in creating a formula on counting the no of employee based on their EmpId when 'Type of Program'- value is

      '"Occ P.I." , "Occ T.I.", and "Occ TWP". I am currently using this formula-

      =((if(ProgramTerm='Occ TWP',Count(EmpId),0)) + (if(ProgramTerm='Occ T.I.',Count(EmpId),0))+(if(ProgramTerm='Occ P.I.',Count(EmpId),0)))

      But it is only giving the result count of "Occ TWP". I wanna how to get the total count of this .

       

      Please find attached excel file along with this that contains those values.

      Any help would be greatly appreciated !

       

      Thank You !