Sum function based on format

[Guest]

I have a long column of numbers.
Some of the numbers are are bolded, and some are not.
I want to get a sum of only the bolded numbers.

Is there an easy way to do this whereby Excel will only add the bolded
numbers?

 

[Richard Buttrey]

I have a long column of numbers.
Some of the numbers are are bolded, and some are not.
I want to get a sum of only the bolded numbers.

Is there an easy way to do this whereby Excel will only add the bolded
numbers?

See my answer to the similar posting earlier, in the thread "calculate
numbers based on font colour' (or color if you're from across the pond


Change the line
If Myrange.Cells(y, 1).Font.ColorIndex = 3 Then

to

If Myrange.Cells(y, 1).Font.Bold = True Then


Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

 

[Paul Sheppard]

I have a long column of numbers.
Some of the numbers are are bolded, and some are not.
I want to get a sum of only the bolded numbers.

Is there an easy way to do this whereby Excel will only add the bolded
numbers?

Hi JMS

Some useful info here ----------
http://www.cpearson.com/excel/colors.ht