If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
payroll
I tried posting this morning and I think it failed so
I'll try again, I want to know if excell will accumalate totals on a weekly basis? ex. I have built a workbook for my employees payroll and as I do thier payroll I would like to have a cell that would add the previous week totals (by week) to come up with a "year to date sum". can anyone help? Thaddeus |
#2
|
|||
|
|||
payroll
I tried posting this morning and I think it failed
David McRitchie posted a reply ; one point he made was that you were "skimpy on the details". As your follow-up is no clearer, I'll assume you haven't seen or can't see his reply. Let's say you have ten employees and that you use ten rows for their details (basic, O/T, tax, NI, etc.) for one week, then another ten rows for the next week, etc., etc. From there, you could use two methods ; 1 - your top row has labels (Name, Employee #, etc.). If eg: actual pay is in column G you could use SUBTOTAL in a free cell in row 1 -- =SUBTOTAL(9,G:G) then (Data --) AutoFilter your table by any employee name to show the sum of his/her amounts in column G. 2 - a pivot table can be used for summarise data ; see http://www.geocities.com/jonpeltier/...pivotstart.htm for starters. HTH, Andy |
Thread Tools | |
Display Modes | |
|
|