How to count names in an Excel timetable

[GeorgeEng]

Hello all Gentlemen!!
In the company I am working now a question was occurred to me , while I was making the weeks schedule I wandered how you could automatically count the each employees shift's. In a timetable where the rows are the days of the week and the columns are the the various positions and in between then are the names of the employees, I questioned my self how you could in a separate cell count in total the number of the shift's that each employee has done. I give you an example of the schedule.









Capture1.PNG

[RandomPezzer]

Hi,

Try:

=SUM(COUNTIF(B2:H8,"Clara"))

the B2:H8 should match the table with the names in it so adjust accordingly to your table

Cheers

[GeorgeEng]

Thank you very much bro !! That helped a lot!
Do you have any idea how I could put in the cells hidden coeficients ??? So for example , for specific "Clara" cells it could be taken as 1 or as 1.25
or as 0.8 ??

Thank you very much