Silly Question But Stuck

[JALonsdale]

I want to calculate two cells based on the number of items I have within sixteen columns on each row.

04

06

08

10

12

14

16

18

20

Next

Total

Line1

x

x

x

x

12

Should Be 28

Line2

x

x

08

Should be 10

Line3

x

x

x

x

x

14

Should be 40

<tbody>
</tbody>

I have figured out the formula in blue as it was rather simple...

=(((COUNTA(b2:b10)*2)+4)

But updating the Total Column is proving more of a challenge.
In this chart there is a line in orange, that cannot be a part of the finished product... Therefore how can I update the total
based on the fact that the first check box value is 4, and it increases each time by 2; without having the 4,6,8,10,12,etc... line in it.

Any feedback would be of much help.

 

[JLGWhiz]

Looks like

=(COUNTA(B2:K2)*2 )+ 4

in M2 and

=SUM(B2:K2)+M2

in N2 based on sample.

 

[shg]

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

1​

04​

06​

08​

10​

12​

14​

16​

18​

20​

Next

Total

2​

Line1

x​

x​

x​

x​

​

​

​

​

​

​

28​

M2: =SUMPRODUCT((B2:J2 = "x") * $B$1:$J$1)

3​

Line2

x​

x​

​

​

​

​

​

​

​

​

10​

4​

Line3

x​

x​

x​

x​

x​

​

​

​

​

​

40​

 

[JALonsdale]

Looks like

=(COUNTA(B2:K2)*2 )+ 4

in M2 and

=SUM(B2:K2)+M2

in N2 based on sample.

Here's what's going on. The first box adds a value of 4, then the next value adds 6, then 8, then 10 and so fourth.

Like I said however, the orange line cannot be in the final product. I'm not sure if I should do a if case tier or sumproduct something.

04

06

08

10

12

14

16

18

20

Next

Total

Line1

x

x

x

x

12

Should Be 28

Line2

x

x

08

Should be 10

Line3

x

x

x

x

x

14

Should be 40

<tbody>
</tbody>

04 + 06 + 08 + 10 is 28, that's how I got that number on line 1.
04 + 06 should be on line 2, 10.
and then the final line is 40, as 4 + 6 + 8 + 10 +12 = 40.

 

[JALonsdale]

thanks.

 

[JALonsdale]

it works... Thank you.