Please help with this
I have multiple ranges with identical horizontal and vertical headers, around 30 ranges and each range called One, Two, Three, etc
Supposedly the horizontal header has A, B, and C
And the vertical header has X, Y, and Z
How could I countblank values under A horizontal header for X vertical header (repeated 30 times to confirm) with one formula?