Hi guys,
I need a way to calculate the values within a colored cells without using sum and manually selecting the cells.
As you can see, in cell B31, this is the sum of the values in the red cells divided by 7.5.
I also need this for B34 but for blue cells.
Please see attached file.
sample.xlsm
Please help! :)
Bookmarks