L
lsmft
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.
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.