Counting Bullets in multiple cells

ajackowski

New Member
Joined
Apr 23, 2015
Messages
5
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,
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
By bullets, do you mean the bullet character · ?

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

ajackowski

New Member
Joined
Apr 23, 2015
Messages
5
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

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,718
Office Version
  1. 2010
Platform
  1. Windows
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

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,884
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

New Member
Joined
Apr 23, 2015
Messages
5
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,399
Messages
5,601,452
Members
414,450
Latest member
Cassy_sn

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top