Count hours next to a specific person ( word )
So, im totally clueless here, but im pretty sure that should be doable.
I need a formula that counts all the hours a worker works, and that the formula searches whole table each time something has been changed, if someone changes shifts etc, that’s just an example table in attachments but hopefully You’ll get the idea.
Let’s say i need to know how many hours have Hamza Kilic, so the formula should search the whole table for name Hamza Kilic and then check the box on the left of the name and count all of these hours together and put the number in O2, and just copy paste for each worker + when i update some of the hours / shifts, the whole formula updates automatically.
English ain’t my first language so sorry for all the mistakes :)
iPad Pro, iPadOS 16