Hi,
I'm trying to create a rota file that will add up multiple visits for care staff in different types of work. Untitled.png this is the spreadsheet I currently have.
I'm trying to add up all H/S hours that each staff member does, and all DCH hours seperately.
At the base of the sheet I currently have a list of all staff names and then columns for HS work, DCH work, admin, DC etc as the pay rates are different.
for the HS and DCH work next to each staff member I have the formula:
=SUMIF($F:$G,"JOBLOGGS",D:D)
(- note - I actually have each staff name in each one)
but it only adds up the hours from column D if the name appears in column F not G.
Please can someone help I'm stumped and feel like it shouldn't be that tricky but for the life of me can't get it to work. If I try having two columns with the same formula but one just for column F and one for column G it still doesn't add up hours if the same appears in column G.
There needs to be 2 columns as often 2 staff members go to the same call.
There seems to be lots of formulas for adding up multiple columns of numbers to match one name, but not adding up numbers from one column from 2 columns of the name, and they don't seem to be working for me in reverse.
Any help would be greatly appreciated.
Bookmarks