Hi,
I have this function, for simplicity's sake it is provided below:
=FREQUENCY(IF(A1:J1<>"", COLUMN(A1:J1)),IF(A1:J1="",COLUMN(A1:J1)))
Cells A1:Z1 are populated with a series of number with blank cells in between them, and the function above calculates how many cells are in a row until a blank cell appears. For example,
<tbody>
</tbody>
So when the function above is Ctrl+Shift+Entered, the output is 2 (three successive cells populated to start), and when I F9 the formula the output is ={2;0;3;0;1}. Is there a way I can implement COUNT in order to count the number of non-zero values in {2;0;3;0;1}, so the output would be 3?
Thank you!!
I have this function, for simplicity's sake it is provided below:
=FREQUENCY(IF(A1:J1<>"", COLUMN(A1:J1)),IF(A1:J1="",COLUMN(A1:J1)))
Cells A1:Z1 are populated with a series of number with blank cells in between them, and the function above calculates how many cells are in a row until a blank cell appears. For example,
A | B | C | D | E | F | G | H | I | J |
10 | 10 | 10 | 10 | 10 | 10 |
<tbody>
</tbody>
So when the function above is Ctrl+Shift+Entered, the output is 2 (three successive cells populated to start), and when I F9 the formula the output is ={2;0;3;0;1}. Is there a way I can implement COUNT in order to count the number of non-zero values in {2;0;3;0;1}, so the output would be 3?
Thank you!!