K
Katie
if i had a column of data and i need to group/subtotal any cells containing
zeros or isolated zeros, wat formula do i put in
eg.
0 )
1 )
0 )
0 ) subtotal = 4 (so i know it was a group of four cells)
4
5
1
6
5
0 )
1 )
0 ) subtotal = 3
6
7
8
0 ) subtotal = 1
basically the data shows steps and rests, and we need to know how long the
rest periods are. single steps surrounded by rest (0) need to be counted as
rest intervals.
zeros or isolated zeros, wat formula do i put in
eg.
0 )
1 )
0 )
0 ) subtotal = 4 (so i know it was a group of four cells)
4
5
1
6
5
0 )
1 )
0 ) subtotal = 3
6
7
8
0 ) subtotal = 1
basically the data shows steps and rests, and we need to know how long the
rest periods are. single steps surrounded by rest (0) need to be counted as
rest intervals.