Hello All...
I have this:
This will work, from the range of Q4:AS4, which is 29 blank cells. However, the numbers stop at BA4 so the COUNTBLANK function begins counting these blank cells.
What I need, is if the cells is blank (no number) in a row, it will count the number of blank cells, then stop at the first cell that has a number.
In the above example, the number would stop at 29 blank cells, because cell 30 in row 4 has a number >=0
Thanks for the help
I have this:
Code:
=COUNTBLANK(Q4:AS4)
This will work, from the range of Q4:AS4, which is 29 blank cells. However, the numbers stop at BA4 so the COUNTBLANK function begins counting these blank cells.
What I need, is if the cells is blank (no number) in a row, it will count the number of blank cells, then stop at the first cell that has a number.
In the above example, the number would stop at 29 blank cells, because cell 30 in row 4 has a number >=0
Thanks for the help