Forum Discussion
Inserting one checkbox and linking to multiple cells to trigger sums
Hi - I am adding checkboxes that are linked to cells to calculate costs. So far I have one check box per cell. I was wanting to link 1 checkbox to 6 cells so that I can check one box and select them ...
It depends on how Exel knows that from row 3 it shall sum till row 8 and from row 10 to row 11. Other words, which formal logic do you use to separate the blocks.
=INDEX($A:$A,INT((ROW()-ROW($A$3))/8)*8+ROW($A$3)) this was the formula in my conditional formatting to identify that rows 3:8 were together. Don't know how I write this to indicate they are in the sum once the A3:A8 is checked to be "true"
SergeiBaklan If it is different I can change the 8 in this formula to the number of rows; however I am only needing a sum formula for this example. Any ideas?
This formula works if each block has exactly 8 rows. But how Excel knows that one block has 8 rows, another one 3 rows, next one 5 rows, etc. ?