#### redspanna

##### Well-known Member

- Joined
- Jul 27, 2005

- Messages
- 1,604

- Office Version
- 365

- Platform
- Windows

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]