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 th...
Formulas & Functions
Need Help
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:

 

 

  • Jennifer Waddingham's avatar
    Jennifer Waddingham
    Copper Contributor
    Feb 09, 2018
    fantastic thank you
  • 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