Forum Discussion
Inserting one checkbox and linking to multiple cells to trigger sums
What would an equation be then to sum rows 3:8 if true and also add in rows 10:11? SergeiBaklan
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.
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. ?
=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"