I totally messed up my last request for a formula.
I have two columns designated for income, Column "A" is for Year To
Date income, column "B" is showing the weekly income.
I am given the YTD income each week.
I use column "B" to reflect each week's income.
We'll say Column "A-1" is the YTD income for the first week of the
year.
Then I'll have Column "B" with Cell "B-1" showing the first week's
income.
Next week YTD will be in cell "A-2" with cell "B-2" showing the second
week's income.
I have used the formula in cell "B-2" for the second week as
=sum(A2-A1).
Problem is when I click and drag the formula down to "B-52" I always
have a negative amount in the "next week to come" cell, equal to the
positve amount YTD income. This leaves me with a "ZERO".
I'm looking for a formula to enter in cell "B-2" that I can click and
drag that will not reflect the negative number to offset the positive
amount of YTD income.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=514430

Try this in B2:

=IF(A2="","",A2-A1)

and copy down to B52 - it will show a blank in column B if there is a
blank in column A.

Hope this helps.

Pete

That works, Thanks much and have a wonderful day !!!


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=514430

Well thank you - it's evening here!

Pete