SUM IF bolded and colored values in Excel
SUMIF Bolded function used to make total for bolded values may be insufficient if you have more complex spreadsheets that require multiple-level totals both columns and rows. Therefore we offer a more efficient solution for such cases. SUM IF for bolded values with different colors. To use this function you need color code for excel which you can find
here.
You will add the code where it will be required in the dialog of function.
The code for bold and colored values:
Option Explicit
Public rCell As Range
Public mySum As Long
Function SumColourFontBold( _
rInputRange As Range, _
myColour As Integer)
'written by: Jack in the UK
'www.excel-it.com
'Excel XP / 2003
Application.Volatile
mySum = 0
On Error Resume Next
For Each rCell In rInputRange.Cells
If rCell.Font.ColorIndex = myColour And rCell.Font.Bold = True Then
mySum = mySum + rCell.Value
End If
Next rCell
On Error GoTo 0
SumColourFontBold = mySum
Call ValKill_SumColourFontBold
End Function
Sub ValKill_SumColourFontBold()
Set rCell = Nothing
End Sub
How you proceed next?
Press ALT+F11 > clik on Insert > then copy the code in module window
Press again ALT+F11
Click on
fx
Select user defined
Double click on SumColourFontBold
Select your value range. Chose your color code (
You can find color code for excel here ) > click enter.
Finish
Excel example
For this example code for Magenta color is 7
Leave a comment