redspanna
Wellknown Member
 Joined
 Jul 27, 2005
 Messages
 1,575
 Office Version

 365
 Platform

 Windows
Hi all,
In column M of my worksheet I have the number 1 in various cells. I need a formula to count the number of times in the whole of column M that the number 1 is shown without the number 1 shown in the cell above or below
..also a formula to count the number of times that the number 1 is shown as series of that number.
for example
1
1
1
1
1
1
1
1
1
1
in the series above the results would be
number 1 by its self = 3
number 1 in groups of 2 = 2
number 1 in groups of 3 = 1
hope this makes sense  and hope you can help
thanks [/img]
In column M of my worksheet I have the number 1 in various cells. I need a formula to count the number of times in the whole of column M that the number 1 is shown without the number 1 shown in the cell above or below
..also a formula to count the number of times that the number 1 is shown as series of that number.
for example
1
1
1
1
1
1
1
1
1
1
in the series above the results would be
number 1 by its self = 3
number 1 in groups of 2 = 2
number 1 in groups of 3 = 1
hope this makes sense  and hope you can help
thanks [/img]