That formula, probably not.
It's about as simple as it's going to get.
But is that a realistic example of what you want, or a shortened/simplified version?
Are you really wanting to do several columns, like C G K O etc.. ?
Is the pattern consistent (every 4 columns) ?
With the 2 ranges being of different sizes (one is row 4 to 9, the other is 3 to 9),
If that is really true, then there probably won't be a simple solution.
But if that was just a typo, and the ranges actually are all the same size, then something can probably be worked out.
But we need the specific details.
Bookmarks