I have a workbook that is generated biweekly for payroll. How can i use the same totals tab (formulas) (in attachment) to total up each pay period?
I have a workbook that is generated biweekly for payroll. How can i use the same totals tab (formulas) (in attachment) to total up each pay period?
What do you want to see? Your current formulae are slighly incorrect... some $ were missing. I've tidied them up. But, what are they NOT doing that you want them to do?
Your explanation is too brief and you provided no expected results, so we're just left guessing.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
I'm so sorry...thank you for updating formula's...each payroll period i will download a workbook like the attached (sheet 1/2...1 sheet per employee) without the totals sheet...how can i copy the totals sheet to that workbook without reference errors,etc?
Thank you again
Hello craig37862 and Welcome to Excel Forum.
Try the following:
1. Right click on the Totals sheet tab
2. Select Move or Copy
3. Select the open workbook to which you want to copy the Totals sheet
4. Select Create a copy
5. Select (move to end)
Note that this assumes that AC will always be on Sheet1, AS Sheet2 etc.
Let us know if you have any questions.
PS Love the Smokey Mountain National Park. Especially elk rut in the fall at the Oconaluftee visitor's center and bears with cubs in the spring in Cade's Cove.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I HAVE A SUMMARY PAGE TAB IN FRONT OF 56 TABS(SHEET1...SHEET2,ETC)...HOW CAN I COPY A FORMULA DOWN A COLUMN ON THE SUMMARY PAGE
...BUT A1 BE FOR SHEET 1...A2 FOR SHEET 2, ETC.
FORMULA IS : =COUNTIF(Sheet1!N1:N33,"LUNCH")
WANTING TO COUNT WHERE "LUNCH" APPEARS ON EACH SHEET
1. Please do NOT use all capitals when replying. That is interpreted as shouting.
2. Please add expected results to the file I attached at post 2, to remove ambiguity.
Without benefit of seeing a sample I am guessing that you want something like this:Formula:=COUNTIFS(INDIRECT("Sheet"&ROWS(A$1:A1)&"!N1:N33"),"Lunch")
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks