adding in a row

[albin]

Is there a way to add the last three none blank cells in a row.
I want to have 12 cells in a row some will have numbers and some wil
not. Just want the last three added as I add more data in the column
from left to right

 

[Andy Brown]

Is there a way to add the last three none blank cells in a row.

I typed this pretty much verbatim into Google & found this from Peo -

=SUM(IV1:INDEX(1:1,LARGE(COLUMN(1:1)*(1:1<>""),3)))

NB - array formula, enter with CTRL+Shift+Enter. Unless of course you need
the result in the same row ...

HTH,
Andy

 

[albin]

Thanks for your response. I have tried this array but am having littl
success.

I will have many rows with 12 columns then a sum column of the las
three none blank columns.

The example is each column is a month and a number will be adde
monthly to most but not all of the columns. I need to know the tota
number for the three most months for each row excluding blanks. Her
is an example of my problem.

a b c d e f g h i j
k l m
1 10 15 25 0 4
44

2 18 0 0 12 6
36

3 0 1 0 21 11
33

Thanks again Albi

 

[Andy Brown]

Albin,

Sorry for the delay, my ISP was down. Adapted from another Peo reply, in M1
;

=SUM(L1:INDEX(A1:L1,LARGE(COLUMN(A1:L1)*(A1:L1<>0),3)))

Copy it into the formula bar, then press CTRL *and* Shift *and* Enter all
together. The formula bar will then show it wrapped in curly braces {}.

From there you can just drag it down.

HTH,
Andy