Sum Of Last Two Entries in Rotating Columns

[Loadmaster]

Hi daddylonglegs came up with the array formula
=SUM(IF(COLUMN(D2:AH13)*100+ROW(D2:AH13)>LARGE((COLUMN(D2:AH13)*100+ROW(D2:AH13))*(
D2:AH13<>""),4), D2:AH13)) . This formula gave me the sum of the last three
entries with the years across the top in row 1 and the months down column C
Now I am looking for the same type of formula only with the last two entries
vice the last three entries. Daddylonglegs post was 7/19/2008 @ 7:26 am PST.

 

[T. Valko]

P.S.

It seems to be counter-intuitive to use n+1 for the variable.

Try this version for the last 2:

=SUM(IF(COLUMN(D2:AH13)*100+ROW(D2:AH13)>=LARGE((COLUMN(D2:AH13)*100+ROW(D2:AH13))*(D2:AH13<>""),2),
D2:AH13))

I changed ">" to ">=" and used the literal variable.

 

[Loadmaster]

Thanks T. Valko, it worked but I also now need a conditional format that if
the value response is < 1 ie -35 that the cell enters 0.

 

[Loadmaster]

forget my last response. In cell B35 I entered your formula. then in cell B34
I entered =30 - B35. If the response is less than 1 enter 0 . If the response
is 1 or greater I would like it to just enter the figure. Sorry for the
confusing last response.

 

[T. Valko]

Try this in B34:

=(30-B35>=1)*B35

 

[Loadmaster]

That didn't answer my question, I was using the array formula
formula=SUM(IF(COLUMN(D2:AH13)*100+ROW(D2:AH13)>=LARGE((COLUMN(D2:AH13)*100+ROW(D2:AH13))*(D2:AH13<>""),2),
D2:AH13)) in cell B35. When I entered the figure 1.0 in Jun of 2009 added to
23.6 in May of 2009 I expected the response to be 5.4 in cell B34 because
that is what is require to reach 30. Had I entered 6.4 or 65.5 or 20.2 in Jun
of 2009 the response should come up with 0 as the figure 30 has already been
met when adding the two figures together.

 

[T. Valko]

Maybe this:

=(30-B35>=1)*(30-B35)