SUM IF bolded and colored values in Excel SUMIF - Excel Tutorial

sum if bolded and colored values in excel

 
  • HOME  • tutorials  • photos   • free grafics design   
   



CATEGORIES
EXCEL TUTORIAL
SQL TUTORIAL
WEB INFORMATION
WINDOWS
JAVASCRIPT SCRIPTS
COMPUTER SECURITY
GRAFIC DESIGN
HTML
PHP
CSS STYLE
ATLAS OF THE WORLD
DEVELOPER
PHOTOSHOP
MAGAZINE
LATEST ARTICLES
how to insert decimal values into a sql table row
asrep.com adsense traking script is down
list of walt disney animated movies
free php and ajax captcha scripts
convert uppercase to lowercase javascript online script
detect and block uppercase (up letters) in a string (form text input) php script
php googlebot detection script
replace breaking lines in text or textarea input using php
rounded borders corners css without images
photoshop styles, asl photoshop style free download
  home   EXCEL TUTORIAL » SUM IF BOLDED AND COLORED VALUES IN EXCEL SUMIF
google ads
 
 
 


SUM IF BOLDED AND COLORED VALUES IN EXCEL


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

sum if bolded and coloured values excel

For this example code for Magenta color is 7


 


ARTICLES IN SUM IF BOLDED AND COLORED VALUES IN EXCEL CATHEGORY

Zero result!!



Tags : SUMIF color Excel,SUM IF excel colored and bolded values,SUMIF bold,






Leave a comment
Your name *
E-mail * ( it not be posted)
Comment title *
Your comment *
   Anti Spam (fill the number CASE SENSITIVE - UP LETTERS ) *

There are no comments ...The page was not find

 

 

the latest articles :
• How to insert decimal values into a SQL table row
• Asrep.com adsense traking script is down
• List of Walt Disney animated movies
• Free PHP and AJAX CAPTCHA scripts
• Convert uppercase to lowercase javascript online script
• Detect and block uppercase (up letters) in a string (form text input) php script
• Php Googlebot detection script
• Replace breaking lines in text or textarea input using php
• Rounded borders corners css without images
• Photoshop styles, asl photoshop style free download

 

eXTReMe Tracker