Sum based on formatting
 

I want to add all the numbers in a column that are bold. It's not a
conditional format, but a manual one. Is there a function for this?


--
cathylou1420
------------------------------------------------------------------------
cathylou1420's Profile: http://www.excelforum.com/member.php...o&userid=36831
View this thread: http://www.excelforum.com/showthread...hreadid=565426

Sum based on formatting
 

Have a look at http://www.mcgimpsey.com/excel/udfs/sumbold.html
--
Hope this helps,
MarkN


"cathylou1420" wrote:


I want to add all the numbers in a column that are bold. It's not a
conditional format, but a manual one. Is there a function for this?


--
cathylou1420
------------------------------------------------------------------------
cathylou1420's Profile: http://www.excelforum.com/member.php...o&userid=36831
View this thread: http://www.excelforum.com/showthread...hreadid=565426

Sum based on formatting
 

This works great. I've never done anything in Visual Basic before.
Cathy


MarkN Wrote:
Have a look at http://www.mcgimpsey.com/excel/udfs/sumbold.html
--
Hope this helps,
MarkN


"cathylou1420" wrote:


I want to add all the numbers in a column that are bold. It's not a
conditional format, but a manual one. Is there a function for this?


--
cathylou1420

------------------------------------------------------------------------
cathylou1420's Profile:
http://www.excelforum.com/member.php...o&userid=36831
View this thread:
http://www.excelforum.com/showthread...hreadid=565426




--
cathylou1420
------------------------------------------------------------------------
cathylou1420's Profile: http://www.excelforum.com/member.php...o&userid=36831
View this thread: http://www.excelforum.com/showthread...hreadid=565426