Maybe this:

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

--
Biff
Microsoft Excel MVP


"Loadmaster" wrote in message
...
That didn't answer my question, I was using the array formula
formula=SUM(IF(COLUMN(D2:AH13)*100+ROW(D2:AH13)=L ARGE((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" wrote:

Try this in B34:

=(30-B35=1)*B35

--
Biff
Microsoft Excel MVP


"Loadmaster" wrote in message
...
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" wrote:

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((C OLUMN(D2:AH13)*100+ROW(D2:AH13))*(D2:AH13<""),2),
D2:AH13))

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


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Replace the 4 with 3.

Don't forget to array enter!

--
Biff
Microsoft Excel MVP


"Loadmaster" wrote in message
...
Hi daddylonglegs came up with the array formula
=SUM(IF(COLUMN(D2:AH13)*100+ROW(D2:AH13)LARGE((CO LUMN(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.