Counting number of Bold Cells in excel

[Woodyuk]

Hi all.
Im trying to get excel to count through a column of cells of data and only count cells which has data, thats been highlight in bold. I then want to put this a total at the end. EG cells A1 to A10 have the data in them, I would like to put in Cell A11 the total of bold items

 

[xlbo]

Can't be done without code

Major mistake that a lot of people make. There are NO internal functions in excel to do anything regarding counting / summing / finding / filtering colours and formatting.

Could be done quite easily if you know any VBA however...

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[SilentAiche]

Woodyuk,

Are your bold cells manually formatted or the result of conditional formatting? If the latter, use CountIf based on the same conditions.

If manually formatted, there must still be some crieria for what is bolded and what is not. Can these conditions be expressed in a CountIf formula?

Good luck!

Tim

[blue]_____________________________________________________
If you need immediate assistance, please raise your hand.
If you are outside of Raleigh, raise your hand and say[/blue] [red]Ooh! Ooh![/red]