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.
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.
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.
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.
Yes, the utility works both for the cells colored manually and with conditional formatting.
Sure! The add-in counts the quantity of colored entries no matter if they are text or numeric cells.
Why not! For this, choose the Sum and Count by All Colors option, it works with all the colors used for font or background.
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.
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 |