Inserting one checkbox and linking to multiple cells to trigger sums

[Jacqueline28]

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 all. Is this possible? I have not found it to work when trying to link the cell and selecting the range. Any advice?

Thanks so much!

[#2]

@Jacqueline28 

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. ?

[#3]

@Sergei Baklan 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?