Forum Discussion
countblank in a range made up of smaller areas
If you have a range of cells (call it MyRange) made up of smaller areas, so that MyRange is never just one 'rectangle' of cells but a few of them (which happen to be adjoining), I find that the funct...
There are ways of dealing with this in Excel 365 insider beta; not exactly mainstream as yet! Your 'little white dog' range comprises 6 areas.
The COUNTBLANK formula works on a single area at a time. I don't think Excel will accept an array of areas so I have used the Lambda helper function MAP to address each in turn. REDUCE does the same but accumulates a result as it goes.
- HI, Peter, just saw your 3 lines of code, now,. Shall take a closer look & get back...
Vincent K
