Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ahmedegypt
- Order by date
-
In a column, Counting successive cells
Thank you for your support- ahmedegypt
- Post #3
- Forum: Microsoft: Office
-
In a column, Counting successive cells
I have a column with values of 0 and 1. I need to count the number of cells containing 1 between cells containing 0 Is there a conditional count or sum formula to get this result in the cell next to each 0 Example: A B 0 3 1 1 1 0 2 1 1 0 5 1 1 1 1 1 0 and so on- ahmedegypt
- Thread
- Replies: 2
- Forum: Microsoft: Office
