Forum Discussion

Jennifer Waddingham's avatar
Jennifer Waddingham
Copper Contributor
Feb 09, 2018

Employee Attendance Tracker Question

Is there are simple formula I can use that counts the number of times a particular letter appears in a list?

For example, S = Sick, how do I calculate the number of times this appears throughout the year. 

Formulas & Functions
Need Help

3 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 09, 2018

    Hi Jennifer,

     

    You can use https://support.office.com/en-us/article/countif-function-e0de10c6-f885-4e71-abb4-1f464816df34?ui=en-US&rs=en-US&ad=US as shown in the below screenshot:

     

     

    • diegoh.petitmon's avatar
      diegoh.petitmon
      Copper Contributor
      Feb 09, 2018

      Hi!

       

      I need a solution to a problem similar to this one. If every letter/code has a number (diferent every time) in the previous column (and multiple columns), how can I work with this data? (I need to figure out how many hours do my team spend in every project (1 code = 1 project) 

      You can see it in the picture below

       Thanks a lot!!!

       

Resources