Hello all,
The formula below will add the number in cell A1 from a workbook called
€˜Monthly Totals to A1 in a book called €˜Yearly Totals.

Is there a way that the formula can be written to check the number at A1 in
€˜Monthly Totals;

And if the number at A1 in €˜Monthly Totals is 0 (zero), dont add it to the
€˜Yearly Totals workbook.

If the number at A1 in €˜Monthly Totals is less than the number at A1 in the
€˜Yearly Totals, add it.

And if the number at A1 in €˜Monthly Totals is greater than the number at A1
in the €˜Yearly Totals, subtract it from the number in the €˜Yearly Totals
workbook.

=SUM('Monthly Totals.xls'!$A$1)

Hopefully this is explained a wee bit better than I had yesterday.

Thank you so much.

-Bad

Ok when I read this it didn't even make sense to me.

What I am looking for is a formula that will keep a running total.

"BadBoy" wrote:

Hello all,
The formula below will add the number in cell A1 from a workbook called
€˜Monthly Totals to A1 in a book called €˜Yearly Totals.

Is there a way that the formula can be written to check the number at A1 in
€˜Monthly Totals;

And if the number at A1 in €˜Monthly Totals is 0 (zero), dont add it to the
€˜Yearly Totals workbook.

If the number at A1 in €˜Monthly Totals is less than the number at A1 in the
€˜Yearly Totals, add it.

And if the number at A1 in €˜Monthly Totals is greater than the number at A1
in the €˜Yearly Totals, subtract it from the number in the €˜Yearly Totals
workbook.

=SUM('Monthly Totals.xls'!$A$1)

Hopefully this is explained a wee bit better than I had yesterday.

Thank you so much.

-Bad