Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | How to sum cells according to their font color in Excel
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

How to sum cells according to their font color in Excel

You will find out how to summarize cells that have a same color of the font, the red  one in my case. Really useful when working with different types of specific data in Excel.

 
  Author: NikMan | Version: 2010 | 27th August 2013 |  
 
 
1.
 

Retype my data in your new Excel spreadsheet.

 
 
2.
 

After that press Alt + F11 keys together to open Microsoft Visual Basic for Applications window.

Click on Insert and choose Module.

 
 
3.
 

Enter the following VBA code:

Function sumcolor(ByVal ref As Range)
Dim cl As Range
sumcolor = 0
For Each cl In ref
    If cl.Font.Color = vbRed And IsNumeric(cl) Then sumcolor = sumcolor + cl
Next
End Function

 
 
4.
 

Close the window.

 
 
5.
 

Click on random empty cell.

 
 
6.
 

Type the following formula:

=sumcolor(A1:A5)

A1:A5 means cells from A1 to A5.

 
 
7.
 

Press Enter key and the cell will summarize all the cells with red font inside.

When data will be modified, you will have to select the cell with formula and confirm it again to refresh the result.

 
 
 
   
  Please login to post a comment
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:25 AM
With Webroot Geek Squad antivirus, you can protect gadgets from malware and other harmful viruses. You can https://sites.google.com/site/bestbuyweb.... Geek antivirus through enter webroot key code for activation With https://sites.google.com/site/webrootgee.... , you can protect gadgets from malware and other harmful viruses. You can download, https://sites.google.com/site/bestbuyweb.... throug webroot.com/safe with webroot keycode. Download and install webroot safe .After it, This is the guide for the download, install and activate the webroot keycode , to protect your device from harmful viruses and threats.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:25 AM
Webroot SecureAnyWhere Antivirus Download webroot for secure your pc from dangerous virus. It is a multi-gadget ant-virus remedy. you can https://sites.google.com/site/installweb.... ,Webroot SecureAnywhere Antivirus is the extensive and dependable ant-virus device which provides an innovative safety to your pc program from harmful as well as severe risks.To https://sites.google.com/site/webrootlog.... , you need to redeem your webroot product key which you will find in your registered mail ID. Through webroot geek squad download you can download, install webroot . https://sites.google.com/site/updatewebr.... to manage webroot key code and install webroot on new computer key subscription.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:26 AM
With Webroot Geek Squad antivirus, you can protect gadgets from malware and other harmful viruses. You can download, install Webroot Geek antivirus through https://sites.google.com/site/webrootant.... for activation With Webroot Geek Squad antivirus, you can protect gadgets from malware and other harmful viruses. https://sites.google.com/site/findmywebr.... , install Webroot Geek antivirus throug https://sites.google.com/site/wwwwebroot.... with webroot keycode.download webroot with key code, Webroot is quick and easy to download, install, and run. Plus, updates are automatic so you always have the most current protection.you may now visit our site.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:27 AM
To activate the https://sites.google.com/site/safewebroo.... , you need to redeem your webroot product key which you will find in your registered mail ID. Through webroot geek squad download you can download, https://sites.google.com/site/webrootweb.... . create a webroot safe account to manage webroot key code and install webroot on new computer key subscription.webroot is a simply used software,install extreme digital security at https://sites.google.com/site/webrootcom.... or at ,click here to download webroot safe.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:29 AM
You can download https://sites.google.com/site/webrootcom.... with key code here. With Webrot's product you will be able to completely protect yourself online and offline.To activate the webroot safe , you need to redeem your https://sites.google.com/site/webrootcom.... which you will find in your registered mail ID. Through webroot geek squad download you can download, install webroot . create a webroot safe account to manage webroot key code and https://sites.google.com/site/windows10i.... on new computer key subscription.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:30 AM
Through Webroot Secure Anywhere, You can protect your computer, pc, and other devices from malware, virus, spyware, etc. You can download https://sites.google.com/site/webrootcom.... , Find my webroot account with key code. After it, you have to follow the process of https://sites.google.com/site/wwwwebroot.... activation.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:31 AM
Setup, download,reinstall, enter and activate your norton product key to https://sites.google.com/site/nortonsetu.... your account . https://sites.google.com/site/nortonnort.... will provide you step-by-step guide for downloading and installation.Present norton in your pc https://sites.google.com/site/nnortoncom...., click here for more details.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:31 AM
Norton internet security is widely used antivirus https://sites.google.com/site/wwwwnorton.... provides the easiest to use and most intutive protection for your computer and your mobiles .follow the complete process by installing and downloading https://sites.google.com/site/nnortonset.... .Install it and forget about viruses,spyware,root-kits, hackers.visit : https://sites.google.com/site/nortonsetu.... for more details.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:32 AM
Norton internet security is widely used antivirus https://sites.google.com/site/nortoncoms.... provides the easiest to use and most intutive protection for your computer and your mobiles .follow the complete process by https://sites.google.com/site/installnor.... .Install it and forget about viruses,spyware,root-kits, hackers.visit : https://sites.google.com/site/downloadno.... for more details.
 
 
  Click to open user profile  
Mahi01, 5th Oct 2020, 7:33 AM
Norton antivirus gives protection in opposition to virus, malware, online threats without harm the device overall performance. It also blocks harmful websites. You may get Norton setup product from the retail shop and also download and install https://sites.google.com/site/enternorto.... from norton.com/setup. You can download, install and activate https://sites.google.com/site/nortonprod.... . click norton.com/setup and follow https://sites.google.com/site/activateno.... for complete the process by
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO