Hi
I have a workbook with daily reports on productivity and i need these figures putting in my weekly total sheet.
please see attached file.
ie Daily hours worked on MON,TUES etc (G3)... need to be totalled and put in column (E3) in the weekly sheet.
Same with the total daily PIFS (H3) to (F3) on weekly.
Any help would be really appreciated.
Thanks
Working 5 day.xlsx
I think you need to do SUMIF--
Like for Tuesday it would be-
=SUMIF(TUES!$D$3:$D$69,D3,TUES!$G$3:$G$69)
now you need to build the same formula for all the sheets and add them up.
Like for Tuesday and monday it would be-
=SUMIF(TUES!$D$3:$D$69,D3,TUES!$G$3:$G$69)+SUMIF(MON!$D$3:$D$69,D3,TUES!$G$3:$G$69)
and so on...
Now for Weekly Pifs the formula would be..
=SUMIF(TUES!$D$3:$D$69,D3,TUES!$H$3:$H$69) for Tuesday and continued for other days...
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
See the attached file
Created a named range for sheet names and used indirect, sumif and sumproduct function
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
OR,
See the attached file!
Please Login or Register to view this content.
Thank you so so much
Thank you also.. you guys are brilliant!!
thank you
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks