Is there a formula to sum info on multiple worksheets that arent on the same line in each?

[Kaykaneetit]

I have created staff rotas showing names, shifts worked on a certain day, holiday or sickness taken etc. It totals up all the hours worked, holiday or sickness taken and works fine as a standalone month. However, its on a shared drive so that managers of the various teams can input all the necessary information, for me to then pick through for payroll.

They have a terrible habit of moving the staff around so they don't appear in the same order on each the worksheets for each month so I am finding it difficult to provide a year to date summary of hours worked, holiday used, sickness days as I am taking the totals from say April, adding these to the totals of May and on the May sheet, showing a ytd value (i.e. April plus May). On June's sheet it will have the total from May plus the amounts from June to give a new year to date total, and so on.

Is there a magic formula that I can insert to get accurate year to date totals regardless of what line they are on, i.e. a SUMIFS using the staff name as the criteria?? Or would it be something else I probably haven't even heard of!!!???

Many thanks

[tim201110]

https://www.excelforum.com/excel-gen...ref-error.html

[oeldere]

You get better help on your question if you add a small excel file, without confidential information.

Please also add manualy the expected result in your file.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.