ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Sum based on Bold Format (https://www.excelbanter.com/excel-discussion-misc-queries/129806-conditional-sum-based-bold-format.html)

Ron

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?

JE McGimpsey

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?


Bob Phillips

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?




Ron

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?




All times are GMT +1. The time now is 04:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com