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.