Home

Employee Attendance Tracker Question

Highlighted
Jennifer Waddingham
New Contributor

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. 

3 Replies

Re: Employee Attendance Tracker Question

Hi Jennifer,

 

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

 

COUNTIF function.png 

Re: Employee Attendance Tracker Question

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

 

Re: Employee Attendance Tracker Question

fantastic thank you