Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 4th 05, 08:25 PM
RAY
 
Posts: n/a
Default 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   Report Post  
Old September 5th 05, 01:56 PM
Bill R
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please help!! Vacation Accrual Formula MissNadine Excel Worksheet Functions 1 August 19th 05 02:32 AM
Vacation Accrual Formula MissNadine Excel Worksheet Functions 0 August 18th 05 04:02 AM
excel formula counting date to date in 4 columns stuie d Excel Worksheet Functions 1 May 4th 05 12:46 PM
Excel formula with date constraints Warrior Pope Excel Discussion (Misc queries) 3 January 28th 05 03:08 PM
Formula with date constraints Warrior Pope Excel Worksheet Functions 1 January 28th 05 02:11 PM


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

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017