COUNTIF bold cell sum if the excel cell value is bolding - How to
> Go to SUMIF Bold
Is it possible? How To?
If you want to count cells that contain bold values (numbers or letters) in a Excel worksheet you can use the Excel COUNTIF function.
But a simple formula udsage is not enough.
You should create a new function that it doesn't exist in Excel COUNTIF basic formulas.
The function code is:
===============
Function CountBold(CellRef As Range)
Dim r As Integer, c As Integer
CountBold = 0
For r = 1 To CellRef.Rows.Count
For c = 1 To CellRef.Columns.Count
If CellRef.Cells(r, c).Font.Bold Then CountBold = CountBold + 1
Next c
Next r
End Function
=====================
What you have to do next?
Open Excel Worksheet - Type ALT + F11
Access Insert and then click on modules
In the window that will appear paste the code (the function).
Close and reopen Excel Worksheet
Use this formula =CountBold(F4:I4))
F4: I4 is your range of values.
That is all.
Leave a comment