May 05 2022 12:54 AM
I have a list of names in Droplist and I have a separate table in the same sheet to calculate the working hours. I want when this finds for example the name George to sum up the total hours that have been registered for him each time. I imagine that they are done with if. Can you help me with this function?
May 05 2022 02:08 AM
May 05 2022 01:22 AM
Solution=SUMIF($G$4:$G$27,C4,$H$4:$H$27)
Maybe with this formula if the dropdown is in cell C4 and the separate table in range $G$4:$H$27.