Sum function based on format
 

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?

On Mon, 5 Sep 2005 07:57:02 -0700, JMS
wrote:

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
__________________________

JMS Wrote:
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.htm


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401946