Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif question
a row as below: 1, 1, 1, 1, 0.8, 0.9, 0.7, 0.5, 1, 0.8,0.6 I need to count all the continuous 1's from the left. Only the 1st (from left) 4 1's need to be counted; the 9th 1 should not be counted. Here the counting results should be 4. I have several hundred rows like this. Please help to suggest a formula. Thanks. -- yeedao ------------------------------------------------------------------------ yeedao's Profile: http://www.excelforum.com/member.php...o&userid=26268 View this thread: http://www.excelforum.com/showthread...hreadid=395619 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif question using 2 conditions | Excel Worksheet Functions | |||
countif question | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions |