Sum function based on format

J

JMS

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?
 
R

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?
Click to expand...

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
__________________________
 
Top