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

Hi Ray,

A circular reference happens when the cells in the formula include the
cell that the formula is in. if you move the formula to another column
or somewhere, this should stop happening.

To get an YTD total, you will need a unique reference, such as a pay
number for the person paid, or similar. Then you would use the SUMIF
formula as below:

=SUMIF(A:A,Pay Number,D:D)

This formula looks for the pay number in column A and returns the total
of the numbers in column D (for example). On your spreadsheet, you need
to use the column with the pay number, then the criteria and then the
amount column. SUMIF(Criteria Range,Criteria,Sum Range)

Rather than type individual criteria into loads of formulas, it is
quicker to copy a list of the pay numbers into the worksheet and use
the formula below:

=SUMIF(A:A,G2,D:D)

This uses the same data as above and G2 is the first pay number. You
then pull this formula down to the bottom of the list of pay numbers.

Hope this works,


Roly


--
roly
------------------------------------------------------------------------
roly's Profile: http://www.excelforum.com/member.php...o&userid=24631
View this thread: http://www.excelforum.com/showthread...hreadid=401817