Sum of only Bold Numbers

[SUHAS KARHADKAR]

Hi all,

I have worksheet that contains almost 700 numbers. Now I want the sum of only BOLD Numbers. I don't want to use VBA.

Sample sheet is attached herewith.

Thanking you.

Regards.

 

[bosco_yip]

Try,

1] Go to Formulas | Define Name .

>> Name : Cell_Is_Bold

>> Refers to : =GET.CELL(20,INDIRECT("RC[-1]",0))

2] Use it in helper I2, copied down :

=Cell_Is_Bold

3] In K2, SumBold formula :

=SUMIF(I:I,TRUE,H:H)

p.s. : Get.Cell() is a Excel 4 Macro function, so you need to save file as xlsm or xlsb.

Regards
Bosco

 

[SUHAS KARHADKAR]

THANX VERY MUCH BOSCO.

Thanking you very much for immediate reply.

There is one thing that I have a large file that is formatted for A3 Page Size and don't have a scope for add a single column. Although I can hide it, but is there any formula without adding the column?

Thanx once again.
Suhas

 

[Lori]

Without helper column, maybe:

1. Define the name 'List' to refer to the column of data (eg $H$2:$H$22)

2. Define the name 'SumBoldList' to refer to:
=SUM(GET.CELL(20,IF(1,+OFFSET(List,ROW(List)-MIN(ROW(List)),)))*List)

3. Enter in a cell:
=SumBoldList

If you're just needing a quick result it can be easier to use the Find (ctrl + F) dialog to select all the bold cells as follows

1. Choose Options >>
2. Click Format... dropdown "Choose Format From Cell..."
3. Click on a bold cell
4. Click Find All
5. Select an item in the List then Ctrl+A to select all items

The status bar at the bottom of the window shows the Sum of selected cells.