Remember Me?

#1
September 4th 05, 08:25 PM
 RAY Posts: n/a
HOW DO WE SET A FORMULA TO FIGURE A YEAR TO DATE TOTAL ??

I AM SETTING UP A SETLEMENT PAY SHEET AND WE WANT TO HAVE A YEAR TO DATE FOR
TOTAL INCOME TOTALS ON SOME OF THE DEDUCTIONS AND SO FORTH BUT IT WILL NOT
LET ME BECAUSE THIS IS ACIRCULAR FUNTION..CAN ANYONE TELL ME IN LAMENS TERMS
HOW THIS HAS TO BE DONE PLEASE THXS

RAY

#3
September 5th 05, 01:56 PM
 Bill R Posts: n/a

I ues this formula for my YTD worksheet:
=SUM(Jan!B14,Feb!B14,March!B14,April!B14,May!B14,J une!B14,July!B14,Aug!B14,Sept!B14,Oct!B14,Nov!B14, Dec!B14)
Hope it helps.

"RAY" wrote:

I AM SETTING UP A SETLEMENT PAY SHEET AND WE WANT TO HAVE A YEAR TO DATE FOR
TOTAL INCOME TOTALS ON SOME OF THE DEDUCTIONS AND SO FORTH BUT IT WILL NOT
LET ME BECAUSE THIS IS ACIRCULAR FUNTION..CAN ANYONE TELL ME IN LAMENS TERMS
HOW THIS HAS TO BE DONE PLEASE THXS

RAY

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post MissNadine Excel Worksheet Functions 1 August 19th 05 02:32 AM MissNadine Excel Worksheet Functions 0 August 18th 05 04:02 AM stuie d Excel Worksheet Functions 1 May 4th 05 12:46 PM Warrior Pope Excel Discussion (Misc queries) 3 January 28th 05 03:08 PM Warrior Pope Excel Worksheet Functions 1 January 28th 05 02:11 PM

All times are GMT +1. The time now is 12:52 PM.