IF criteria - cell characteristics

davidbutov 

Here is another example without VBA

Sum of all bold cell values

Go to: Formulas -> "Define Name"

Set a custom name:

Insert -> Name -> Define -> Name in the table: 'Bold' ->

Refers to:

English:

= ASSIGN.CELL(20,Sheet1!$A1)*1

German:

=ZELLE.ZUORDNEN(20;Tabelle1!$A1)*1

(In the inserted example file you will find the correct settings for the table under the name manager.)

Now you can use the following column in any auxiliary column (here column B)

Enter formula:

= Bold

And get a 1 if the cell in the same row in column A is bold

is formatted.

Now you can use SUMMIF () to calculate the sum:

= SUMIF(B:B,1,A:A)

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.