Counting Bullets in multiple cells

[ajackowski]

Counting Bullets in multiple cells

Good day
I’m creating a product comparison checklist for a product I’m looking to purchase. Is there are way to count/tally the bullets at the bottom of the checklist to see which product scored the highest? I have about 85 requirements the product has to be graded against.

Thanks,

 

[Scott Huish]

By bullets, do you mean the bullet character · ?

=COUNTIF(A50:A100,"·*")

 

[ajackowski]

Thank you for the quick reply.
I used =COUNTIF(C13:C86,CHAR(108)) so I could get a Wingdings bullet AKA lower case "l" in regular fonts to show up in the cell.

 

[Rick Rothstein]

Thank you for the quick reply.
I used =COUNTIF(C13:C86,CHAR(108)) so I could get a Wingdings bullet AKA lower case "l" in regular fonts to show up in the cell.

You forgot the asterisk...

=COUNTIF(C13:C86,CHAR(108)&"*")

Note, since the character is a lower case L, you should be able to use that directly...

=COUNTIF(C13:C86,"l*")

However, if you have any cells that start with an upper or lower case "L", those will be counted as well (for either of the above formulas). Do all your cells start with a bullet? Do any of your cells have multiple bullets in them (the above formulas will only count one bullet per cell)?

 

[pgc01]

Hi

Also, just a remark: why are you using the wingdings font?

You could use the unicode bullet, you would not have to change fonts and it would not be a problem to count, since there would be no confusion between the bullet and an "l" character.

 

[ajackowski]

I have crude excel skills, on a time crunch and using the skills that I know . Only one bullet per cell is required. But thanks for the tips and speedy replies.

cheers