- Home
- Products
- Ultimate Suite for Excel
- Count & Sum by Color
Sum and count colored cells in Excel
Calculate your data by background or font color
Make use of this handy tool whenever you need to sum cells by font or background color, or count the number of such cells. Besides, it can find average, minimum and maximum values in a range of cells colored manually or with Excel conditional formatting.
With Count & Sum by Color you will
- Sum and count by one or by all colors Count and sum cells by one color or by all colors used in your worksheet.
- Calculate cells by font color Find out the number of cells with the same font color or sum their values.
- Compute cells colored by conditional formatting Whether your cells are shaded manually or with a conditional formatting rule, they are summed and counted equally well.
- Paste the result as a formula You can insert the result of the calculations as a formula and it will be recalculated each time the data in the selection changes.
- Find average, minimum, and maximum Get the average of colored cells as well as the minimum or maximum value.
- Count and sum cells by fill color Select the background color to sum and count cells in your Excel worksheet.
- Paste the results to any location of your workbook See the summary results on the add-in pane and insert them into any place of your Excel book.
- Get a number of custom Ablebits functions The tool offers not only handy options for your colored cells but also additional functions that you can use in your formulas.
How to count cells by color in Excel
Frequently asked questions
What is Count & Sum by Color and what do I need it for?
This utility sums and counts cells based on font or background color and shows average, minimum and maximum values in a range. It is up to you to choose whether to count and sum cells by only one color or by all colors in your worksheet.
Don't COUNTIF and SUMIF functions do the same in Excel?
No, there are no native ways to sum and count by color. The only way to count colored cells in Excel without additional tools is to write your own VBA code.
How to count by color in Excel with this tool?
Select the range, click on the Sum by Color icon and choose one of the options: Sum and Count by one Color or Sum and Count by All Colors. If you've chosen to work with only one color, click the Color Picker icon next to the Pick any cell with color field and select a pattern cell in your table that represents the formatting you need. Depending on your task, tick either Background or Font. Click the Calculate button and see the result right in the add-in pane. To insert the result, click Paste results button.
Please find a more detailed description here.
Does Count & Sum by Color work for cells with conditional formatting?
Yes, the utility works both for the cells colored manually and with conditional formatting.
Can I count the number of colored text cells?
Sure! The add-in counts the quantity of colored entries no matter if they are text or numeric cells.
I have many cells colored differently and need to count all cells of each color, is it possible?
Why not! For this, choose the Sum and Count by All Colors option, it works with all the colors used for font or background.
Can I get the result recalculated automatically if my data changes?
Yes, you can insert the result as a formula created with custom Ablebits functions. In this case, each time numerical data in the selection changes, the pasted result will be changed too.
Choose your Ultimate Suite edition
Count & Sum by Color + 70 other time-saving tools in one powerful suite
| Personal | Business | Business, 5 seats | |
| One-time purchase You pay only once and can use the purchased version as long as you need. |
|||
| Unconditional 60-day money back guarantee If you are not 100% happy with the product, you can cancel an order and get your money back with no questions asked. |
|||
Volume discounts
|
|||
| Support for Excel 2019 – 2010 All Excel versions 2019–2010 are supported, both 32- and 64-bit. Also, all desktop Excel versions included in Office 365 subscriptions. |
|||
| Free upgrades for 2 years During 2 years after the purchase you get all minor updates and major upgrades for free. |
|||
| License for | Single user | Single user | 5 users |
| Technical support service Our support team is always happy to help you via email, live chat, or phone no matter how long ago you purchased your license. |
|||
| Corporate deployment (GPO, SCCM) Your system administrator can quickly and easily deploy Ultimate Suite for a group of users without even disturbing them. |
|||
| Features and hotfixes on request We’ll do everything in our power to create additional features you need and fix the found bugs as soon as possible. |
|||
May Offer
Enjoy Ultimate Suite
with up to 30% discount Offer ends May, 25th
|
$69 $99 Buy now |
$11995 $14995 Buy now |
$29996 $375 Buy now |
Supported versions
Microsoft Excel
- Excel included in Microsoft 365 (formerly Office 365)
- Excel 2021
- Excel 2020
- Excel 2019
- Excel 2016
- Excel 2013
- Excel 2010
- 32-bit and 64-bit
- Note! Office Insider is not supported
Windows
- Windows 11
- Windows 10
- Windows 8.1
- Windows 8
- Windows 7
- 32-bit and 64-bit
- Note! Windows Insider is not supported
- Note! Windows X (on ARM processors) is not supported
Any questions or comments?
Please contact us here
War in Ukraine. Here's what Ablebits is doing to make sure our team and projects are safe.
