How to sum numbers in the row as many as the numbers in a column

[LA_Enjoy]

Hi my friends,

Please help me,

I want to add column in tabel.

How to sum numbers in the row as many as the numbers in a column.

Here is the data sample and my expected result in last column.

I want to sum up item 1 until item 10 as many as 8 in row 1

Passage_item	Item 1	Item 2	Item 3	Item 4	Item 5	Item 6	Item 7	Item 8	Item 9	Item 10	Result
8	1	0	1	0	1	1	0	1	0	1	5
9	1	1	0	1	1	0	1	1	0	1	6
9	1	1	1	1	1	1	1	1	1	1	9
10	1	0	1	0	1	0	1	0	1	1	6
10	1	1	0	0	1	1	0	1	1	1	7

Thanks for Help

[tamerj1]

Hi @LA_Enjoy 

how does the source data table look like?

[LA_Enjoy]

Hello @tamerj1,

Source data look like this picture

[tamerj1 · Accepted solution]

@LA_Enjoy 
Please refer to attached sample file for all the details. The solution invoves many steps but all are simple.

[LA_Enjoy]

Thanks man

[LA_Enjoy]

I used this formula in excel

=SUMIF($B$1:$K$1;"<="&$A2;$B2:$K2)