Forum Discussion
Solved
@COUNTBLANK
The @countblank function is not helping me 😞 Some of the cells are actually merged cells...' For example, some cells are only one cell long, and other cells are merged - spanning 5 cells. ...
- I don't understand why it worked for you.. but here is what I have encountered (an example)
B2 4-May
B3 5/3/2021
B4
B5
B6 4-May
B7
B8 5-May
B9 6-May
B10 7-May
B11
B12
B13 8-May
B14 9-May
B15
B16
B17
B18 10-May
9 "=COUNT(B2:B18)"
It works for me.
A1 has a value. B1 and C1 are empty. A1:C1 are merged.
=COUNTBLANK(A1:C1)Result is 2.
I don't understand why it worked for you.. but here is what I have encountered (an example)
B2 4-May
B3 5/3/2021
B4
B5
B6 4-May
B7
B8 5-May
B9 6-May
B10 7-May
B11
B12
B13 8-May
B14 9-May
B15
B16
B17
B18 10-May
9 "=COUNT(B2:B18)"
B2 4-May
B3 5/3/2021
B4
B5
B6 4-May
B7
B8 5-May
B9 6-May
B10 7-May
B11
B12
B13 8-May
B14 9-May
B15
B16
B17
B18 10-May
9 "=COUNT(B2:B18)"
- COUNTBLANK() is my intended use... 😉