keep\update sum value
 

I would like to keep my total hours worked (sum) for the month.
Update the next month and have my (sum) not lose info but let me add to it,
the new month.
This is current formula:
=SUM(D7*3,C7*2,B7*1.5)
If I clear D7, C7, B7 - I now lose my data in SUM field.

This box (sum) is repeated several times, all dif. employees.
How do I keep a sum from losing its value? And allow it to be updated (add)
new hours to it?

The best way is to create a sheet for every month, and to move every month's
data to the appropriate sheet. You should also add a column to record
accumulated hours worked. This can be done with a macro, to automate the
process.

In this way you buil up a record for the whole year, for every employee. I
have created a workbook that does exactly this, and then also prints out
payslips containing all the relevant info. I used the following columns:
A: Surname; B: Initials; D: Date appointed; E: Salary; F: Commission; G:
Bonus; H: Overtime; I: Other income; J: Gross Salary; K: Income Tax; L: UIF;
M: Medical; N: Pension; O: Other Deductions; P: Total Deductions; Q: Nett
Wages; R: Leave Accumulated; S: Leave earned this month; T: Leave taken this
month; U: Leave credit remains; V: Sick leave for year; W: This Cycle; X:
Total; Y: Wages accumulated1; Z: Wages Accumulated2; AA: Comm Acc1; AB: Comm
Acc2; AC: Other Acc1; AD: Other Acc2; AE: Tax Acc1; AF: Tax Acc2; AG: UIF
Acc1; AH:UIF Acc2.

If you think this can help you, I can send you the file, with the necessary
formulae and macro's. Will need your email address though

"stef" wrote:

I would like to keep my total hours worked (sum) for the month.
Update the next month and have my (sum) not lose info but let me add to it,
the new month.
This is current formula:
=SUM(D7*3,C7*2,B7*1.5)
If I clear D7, C7, B7 - I now lose my data in SUM field.

This box (sum) is repeated several times, all dif. employees.
How do I keep a sum from losing its value? And allow it to be updated (add)
new hours to it?

Yes I would like to see what you have, sounds as if it will work. email:

Thank you
"Kassie" wrote:

The best way is to create a sheet for every month, and to move every month's
data to the appropriate sheet. You should also add a column to record
accumulated hours worked. This can be done with a macro, to automate the
process.

In this way you buil up a record for the whole year, for every employee. I
have created a workbook that does exactly this, and then also prints out
payslips containing all the relevant info. I used the following columns:
A: Surname; B: Initials; D: Date appointed; E: Salary; F: Commission; G:
Bonus; H: Overtime; I: Other income; J: Gross Salary; K: Income Tax; L: UIF;
M: Medical; N: Pension; O: Other Deductions; P: Total Deductions; Q: Nett
Wages; R: Leave Accumulated; S: Leave earned this month; T: Leave taken this
month; U: Leave credit remains; V: Sick leave for year; W: This Cycle; X:
Total; Y: Wages accumulated1; Z: Wages Accumulated2; AA: Comm Acc1; AB: Comm
Acc2; AC: Other Acc1; AD: Other Acc2; AE: Tax Acc1; AF: Tax Acc2; AG: UIF
Acc1; AH:UIF Acc2.

If you think this can help you, I can send you the file, with the necessary
formulae and macro's. Will need your email address though

"stef" wrote:

I would like to keep my total hours worked (sum) for the month.
Update the next month and have my (sum) not lose info but let me add to it,
the new month.
This is current formula:
=SUM(D7*3,C7*2,B7*1.5)
If I clear D7, C7, B7 - I now lose my data in SUM field.

This box (sum) is repeated several times, all dif. employees.
How do I keep a sum from losing its value? And allow it to be updated (add)
new hours to it?