payroll

[Thaddeus]

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

 

[Andy Brown]

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/Excel/Pivots/pivotstart.htm for
starters.

HTH,
Andy