Conditional formula with multi tasks

B

BadBoy

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), don’t 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
 
B

BadBoy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine information from two pages, two changing locations. 6
Finding next empty row 5
Search 2
Formula help please 1
Multi-Condition Formula 5
Moving data from one workbook to another workbook 1
Automatically add and subtract 3
Linking data from a new sheet (semi-)automatically 1

Top