Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Conditional Sum based on Bold Format

Is there a way to sum only those numbers in a column based on whether or not
they are formatted as bold?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Conditional Sum based on Bold Format

See

http://www.mcgimpsey.com/excel/udfs/sumbold.html

In article ,
Ron wrote:

Is there a way to sum only those numbers in a column based on whether or not
they are formatted as bold?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Conditional Sum based on Bold Format

See http://tinyurl.com/3xvtx9

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ron" wrote in message
...
Is there a way to sum only those numbers in a column based on whether or

not
they are formatted as bold?



  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Conditional Sum based on Bold Format

Eureka!

It works great.

Thank you,

Ron

"JE McGimpsey" wrote:

See

http://www.mcgimpsey.com/excel/udfs/sumbold.html

In article ,
Ron wrote:

Is there a way to sum only those numbers in a column based on whether or not
they are formatted as bold?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format a column based on another Karm Excel Discussion (Misc queries) 6 October 30th 06 11:39 AM
Conditional Format based on Other Cells Fletch Excel Discussion (Misc queries) 2 October 10th 06 02:03 PM
Conditional Format - 3 conditions Mike Saffer Excel Worksheet Functions 3 April 13th 06 07:35 PM
Conditional Format based on contents of cell. dave m Excel Worksheet Functions 13 April 29th 05 01:12 PM
How do I do conditional format based on a cell with a formula? Justin Excel Worksheet Functions 9 December 17th 04 02:05 PM


All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"