how do i keep running ytd salary totals?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Good Tipper - 16 Oct 2006 02:46 GMT

I create a new spreadsheet every week that tracks employee tips. Each
employee has their own sheet in the workbook, and each week has its own
workbook. The employee sheets have their hours worked each day of the week,
their tips calcualted for the day, and their tip total for the week.

I want to create a formula that keeps a running total of employee tips
throughout the year (YTD Tips). I create the current weeks sheet by opening
the previous week and replacing the information. Let's say the Weekly Tips
cell is A10. I want A10 added to the YTD cell everyweek, and to update
automatically every week. Is that possible? Hope I explained it ok. Thanks
for any recommendations.

Reply to this Message

Fred Smith - 17 Oct 2006 01:18 GMT

You are asking for trouble by replacing the information every week. What if you
type in the wrong amount? What if you want to make a correction? How does anyone
check your work?

The standard method of handling this problem would be to create a list of tips
received throughout the year. Your rows would have the date, amount, and
anything else you wanted to track. Your YTD Tips is simply the sum of all rows.

The most popular setup would be to have a header is row 1 (allowing a title for
each column), the sum in row 2 (as in =sum(B:B)), and your data in subsequent
rows.

If you insist on replacing the data every week, you will need a macro to capture
the amount, then add it to your YTD amount.

Signature

Regards,
Fred

>I create a new spreadsheet every week that tracks employee tips. Each
> employee has their own sheet in the workbook, and each week has its own
[quoted text clipped - 7 lines]
> automatically every week. Is that possible? Hope I explained it ok. Thanks
> for any recommendations.

Reply to this Message