Dreevoo.com | Online Learning and Knowledge Sharing

English | Login & Registration

CONTRIBUTE

FORUM

INFO

| Programs | Microsoft Office | Microsoft Excel | How to sum cells according to their font color in Excel

Guest

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 |

Comment ( 44 )

Retype my data in your new Excel spreadsheet.

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

Click on Insert and choose Module.

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

Close the window.

Click on random empty cell.

Type the following formula:

=sumcolor(A1:A5)

A1:A5 means cells from A1 to A5.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

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.

Retype my data in your new Excel spreadsheet.

After that press Alt + F11 keys together to open Microsoft Visual Basic for Applications window.Click on Insert and choose Module.

Enter the following VBA code:Function sumcolor(ByVal ref As Range)Dim cl As Rangesumcolor = 0For Each cl In ref If cl.Font.Color = vbRed And IsNumeric(cl) Then sumcolor = sumcolor + clNextEnd Function