Sum Of Last Two Entries in Rotating Columns
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.
|