multiple if statement

M

monical99

I am tracking un-recognized costs for the whole year. My data have 1
columns Jan, Feb...Dec. I want to have a total column showing th
remaining un-recognized costs. For example in cell A1 I entered 6 fo
June , then in A2 I want the formula to sum the numbers in July throug
Dec. Next month, I change cell A1 to 7, then I want A2 to sum Au
through Dec.

Can anyone help me write this?
Thank
 
J

Jason Morin

If your months are listed in B1:M1 and the costs are
found directly below in B2:M2, use this in A1:

=SUM(OFFSET(B2,,A1,,12))

HTH
Jason
Atlanta, GA
 
J

Jason Morin

Sorry, I mean insert the formula into A2.
-----Original Message-----
If your months are listed in B1:M1 and the costs are
found directly below in B2:M2, use this in A1:

=SUM(OFFSET(B2,,A1,,12))

HTH
Jason
Atlanta, GA
I
entered 6 for
.
Click to expand...
 
Top