JALonsdale
New Member
- Joined
- Jul 29, 2017
- Messages
- 6
I want to calculate two cells based on the number of items I have within sixteen columns on each row.
<tbody>
</tbody>
I have figured out the formula in blue as it was rather simple...
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.
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...
Code:
=(((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.