Employee Attendance Tracker Question

[Jennifer Waddingham]

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. 

[#2]

Hi Jennifer,

You can use COUNTIF function as shown in the below screenshot:

 

[#3]

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!!!

[#4]

fantastic thank you