Count cells in excell that are wrapped
Posted by JOHN on December 18, 2000 4:42 PM
I want to count cells in an excel file: need to count all the M1 activity
12-965129532-A 0 89001 3013421222 8012000 432
12-965129532-~ 58 ~ M1 0.3
19-965130764-A 0 89001 9736276459 8012000 452
19-965130764-~ 135 ~ M1 C2786-00021C 440012558
10-965131411-A 0 89001 5023645000 8012000 503
10-965131411-B 72 B M1 1826-0423 440012558
10-965131411-~ 75 ~
00-965131715-A 0 89001 9372983940 8012000 508
21-965131803-A 0 89001 9182944000 8012000 510
00-965131715-~ 109 ~ M1 0.3
21-965131803-~ 99 ~ M1 M1094-68004 440012558
22-965131905-A 0 89001 9315268485 8012000 511
22-965131905-~ 125 ~ M2 0.3 440012558
Posted by Aladin Akyurek on December 19, 2000 3:04 AM
Doesn't
=COUNTIF(Range,"M1")
work, assuming that you want to count cells which contain just "M1"?
Aladin
Posted by JOHN NAVARRO on December 19, 2000 12:40 PM
Re: Count mulit-cells in excell that are wrapped
also want to multi count example m1's with an open statement and with a cell of 36792.
