Hi everyone!
I need to fill the cells highlighted in yellow with totals.
For example
First table
If there are N at least min 2 next to each other, it is supposed to count the sum in the selected place.
24+24+8= 56
D10 + F10+ H9 = H13
After is a empty cell and then we start count next cells with N
8+24+24+24+24= 96
1-I9+J9+L9+N9+P9 = P13
If there will be N next to each other max 7, then in the cell with the last N it should show the sum of all N next to each other, etc.
Configurations can be different, so a dynamic formula is needed
I will be very grateful for all replies !
I need to fill the cells highlighted in yellow with totals.
For example
First table
If there are N at least min 2 next to each other, it is supposed to count the sum in the selected place.
24+24+8= 56
D10 + F10+ H9 = H13
After is a empty cell and then we start count next cells with N
8+24+24+24+24= 96
1-I9+J9+L9+N9+P9 = P13
If there will be N next to each other max 7, then in the cell with the last N it should show the sum of all N next to each other, etc.
Configurations can be different, so a dynamic formula is needed
I will be very grateful for all replies !