How to combine ranges of cells into an array?

Question

excel

I'm trying to count all the diagonal minors of a matrix. For the first and last element no difficulty:

spoiler

For the remaining elements, I can’t figure out how to combine a set of ranges or how to exclude a row and column from a range, I tried to do something like this:

spoiler

But instead of merging, it stupidly adds numbers.

Answer 1

Well, you can use named ranges
"Formulas" panel - "Name Manager"
Create a new name and when selecting a range, select all the cells you need using Ctrl
Then use this name
in the formula To insert into the formula, you can use the "Formulas" command - "Use in Formula"
Or count with VBA