Need to create a formula that will add the weekly pa amount to the YTD for stub total

[TABLE="width: 626"]

[tr]

[TD="class: xl63, width: 154"]Column1
[/TD]
[TD="width: 370"]Column2
[/TD]
[TD="class: xl65, width: 154"]Column3
[/TD]
[TD="class: xl65, width: 154"]Column4
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"]Gross Pay
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]1042.75
[/TD]
[TD="class: xl65, bgcolor: transparent"]17726.75
[/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"]Deductions
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]FICA Withholding
[/TD]
[TD="class: xl64, bgcolor: transparent"]63.57
[/TD]
[TD="class: xl64, bgcolor: transparent"]1080.74
[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Medicare Withholding
[/TD]
[TD="class: xl64, bgcolor: transparent"]14.87
[/TD]
[TD="class: xl64, bgcolor: transparent"]252.78
[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Federal Withholding
[/TD]
[TD="class: xl64, bgcolor: transparent"]48.18
[/TD]
[TD="class: xl64, bgcolor: transparent"]819
[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]State Withholding
[/TD]
[TD="class: xl64, bgcolor: transparent"]33.97
[/TD]
[TD="class: xl64, bgcolor: transparent"]577.44
[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]County Withholding
[/TD]
[TD="class: xl64, bgcolor: transparent"]16.15
[/TD]
[TD="class: xl64, bgcolor: transparent"]274.54
[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Dental Deduction
[/TD]
[TD="class: xl64, bgcolor: transparent"]17.29
[/TD]
[TD="class: xl64, bgcolor: transparent"]293.93
[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]401-K Deduction
[/TD]
[TD="class: xl64, bgcolor: transparent"]20.86
[/TD]
[TD="class: xl64, bgcolor: transparent"]354.62
[/TD]

[/tr]

[tr]

[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]
[TD="class: xl64, bgcolor: transparent"][/TD]

[/tr]

[tr]

[TD="class: xl63, bgcolor: transparent"]Net Pay
[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]827.86
[/TD]
[TD="class: xl65, bgcolor: transparent"]14073.62
[/TD]

[/tr]

[/TABLE]

Re: Need to create a formula that will add the weekly pa amount to the YTD for stub t

This is a copy of the paystub that I am creating. I need column 3 amounts added to column 4 totals weekly. I don't want to have to go in and manually do it every week. Is there a way to automate this process.