Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Ray,
Can you give an example of what it is you are trying to calculate in mixed case type face - typing in all capitals is regarded in the Newsgroups as rude because it taken a SHOUTING! Additionally it is harder to read especially for people whose first language in not English. -- Regards Sandy Replace@mailinator with @tiscali.co.uk "RAY" wrote in message ... 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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help!! Vacation Accrual Formula | Excel Worksheet Functions | |||
Vacation Accrual Formula | Excel Worksheet Functions | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Excel formula with date constraints | Excel Discussion (Misc queries) | |||
Formula with date constraints | Excel Worksheet Functions |