Count the occurance of "1)"

[RichardMau5]

Hello Guys,

While I was working on my scription, I needed to count the occurance of "1)"
Excel finds it really hard to do this, I believe.

This is a little piece of my data:

[TABLE="width: 640"]
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64"]0 (1,0)[/TD]
[TD="class: xl64, width: 64"]1 (2,1)[/TD]
[TD="class: xl64, width: 64"]2 (2,1)[/TD]
[TD="class: xl64, width: 64"]3 (2,2)[/TD]
[TD="class: xl64, width: 64"]5 (2,2)[/TD]
[TD="class: xl64, width: 64"]6 (2,2)[/TD]
[TD="class: xl64, width: 64"]9 (2,2)[/TD]
[TD="class: xl64, width: 64"]11 (2,3)[/TD]
[TD="class: xl64, width: 64"]18 (2,2)[/TD]
[TD="class: xl64, width: 64"]20 (2,2)[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]24 (2,2)[/TD]
[TD="class: xl64, width: 64"]25 (2,3)[/TD]
[TD="class: xl64, width: 64"]26 (2,3)[/TD]
[TD="class: xl64, width: 64"]28 (2,3)[/TD]
[TD="class: xl64, width: 64"]32 (2,1)[/TD]
[TD="class: xl64, width: 64"]33 (2,2)[/TD]
[TD="class: xl64, width: 64"]34 (2,2)[/TD]
[TD="class: xl64, width: 64"]36 (2,2)[/TD]
[TD="class: xl64, width: 64"]40 (2,2)[/TD]
[TD="class: xl64, width: 64"]41 (2,3)[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]56 (2,3)[/TD]
[TD="class: xl64, width: 64"]80 (2,2)[/TD]
[TD="class: xl64, width: 64"]85 (2,4)[/TD]
[TD="class: xl64, width: 64"]88 (2,3)[/TD]
[TD="class: xl64, width: 64"]96 (2,2)[/TD]
[TD="class: xl64, width: 64"]144 (2,2)[/TD]
[TD="class: xl64, width: 64"]145 (2,3)[/TD]
[TD="class: xl64, width: 64"]146 (2,3)[/TD]
[TD="class: xl64, width: 64"]153 (2,4)[/TD]
[TD="class: xl64, width: 64"]176 (2,3)[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]260 (2,2)[/TD]
[TD="class: xl64, width: 64"]264 (2,2)[/TD]
[TD="class: xl64, width: 64"]265 (2,3)[/TD]
[TD="class: xl64, width: 64"]266 (2,3)[/TD]
[TD="class: xl64, width: 64"]268 (2,3)[/TD]
[TD="class: xl64, width: 64"]280 (2,3)[/TD]
[TD="class: xl64, width: 64"]296 (2,3)[/TD]
[TD="class: xl64, width: 64"]320 (2,2)[/TD]
[TD="class: xl64, width: 64"]328 (2,3)[/TD]
[TD="class: xl64, width: 64"]384 (2,2)[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]385 (2,3)[/TD]
[TD="class: xl64, width: 64"]386 (2,3)[/TD]
[TD="class: xl64, width: 64"]388 (2,3)[/TD]
[TD="class: xl64, width: 64"]392 (2,3)[/TD]
[TD="class: xl64, width: 64"]393 (2,4)[/TD]
[TD="class: xl64, width: 64"]400 (2,3)[/TD]
[TD="class: xl64, width: 64"]408 (2,4)[/TD]
[TD="class: xl64, width: 64"]416 (2,3)[/TD]
[TD="class: xl64, width: 64"]448 (2,3)[/TD]
[TD="class: xl64, width: 64"]520 (2,2)[/TD]
[/TR]
[TR]
[TD="class: xl64, width: 64"]521 (2,3)[/TD]
[TD="class: xl64, width: 64"]536 (2,3)[/TD]
[TD="class: xl64, width: 64"]576 (2,2)[/TD]
[TD="class: xl64, width: 64"]641 (2,3)[/TD]
[TD="class: xl64, width: 64"]656 (2,3)[/TD]
[TD="class: xl64, width: 64"]776 (2,3)[/TD]
[TD="class: xl64, width: 64"]1285 (2,4)[/TD]
[TD="class: xl64, width: 64"]1288 (2,3)[/TD]
[TD="class: xl64, width: 64"]1360 (2,4)[/TD]
[TD="class: xl64, width: 64"]2305 (2,3)
[/TD]
[/TR]
</tbody>[/TABLE]

So, I want to filter out, how many ,1) or 1)'s there are, how many 2)'s etc.

Is this actually possible?

Many thanks beforehand

 

[NBVC]

Maybe with COUNTIF?

e/g/

=COUNTIF(A1:J6,",1)")

 

[Jonmo1]

Maybe with COUNTIF?

e/g/

=COUNTIF(A1:J6,",1)")

Probably need to add a wildcard in there..

=COUNTIF(A1:J6,"*,1)")

 

[RichardMau5]

Holymoly, it worked. Had to edit a bit to

=COUNTIF((A1:J6); "*,1)")

Thankyou so, so much guys!

 

[pgc01]

Hi Richard

Do you really need to enclose the reference in parentheses?

=COUNTIF((A1:J6); "*,1)")

Try deleting those parentheses.

 

[NBVC]

Thanks for the correction, jonmo