﻿ Count and Sum by Color – Ablebits app for Excel for Mac

# Count & Sum by Color app for Excel for Mac

## Count and sum colored cells in Excel for Mac

With Сount & Sum by Color app for Excel for Mac, you can easily sum and count cell data by the color of their background or font. The app's pane lets you easily calculate color-coded cells in your tables:

• Automatically sum and count colored cells in Excel for Mac
• Use the All Colors tab to see the results for all highlighted cells
• Click the One Color tab to specify the color and see Sum, Count, Average, Max and Min
• Insert the calculation results into your table

Learn how to work with the app.

### Sum and count cells in your worksheet by color

If you often deal with Excel tables that have colored cells you need to calculate, just get the Сount & Sum by Color app in your Excel: go to the App Store -> click Free -> Install App.

Say you have a large list with projects. The rows with projects given financing are green, those waiting for a reply from the sponsor are yellow, and the closed projects are red. You need to quickly count all projects in each group and sum the group's budgets for a weekly report.

You can simultaneously count and sum green, yellow and red cells and see the results on the app's pane. Just select the table with your data, specify if you need to use the color of font or background, select the math operation and click Calculate. You'll see the results that you can then choose to paste anywhere in your table.

### Select certain color in your table to calculate cell values

If you use multiple different colors in your table and need to pick just one color for calculation, choose the One color tab on the app's pane. This tab lets you pick any cell with the needed font or background color in your table and see Sum, Count, Average, Min and Max for the identically highlighted values.

It's really convenient since you don't need to know the code of the color, you just pick it from your list. You can also paste the result to your workbook for tracking purposes. Thus, the Сount & Sum by Color app for Mac will become your reliable assistant in dealing with highlighted cells.

The current version of Count & Sum by Color is free.
You can add it to your Excel 2011 from the App Store.

### Сount & Sum by Color for Mac system requirements

#### Operating System

• OS X 10.9 or later, 64-bit processor

#### Microsoft Excel

• Microsoft Excel 2016 for Mac
• Desktop version of Office 365 for Mac
• Microsoft Excel 2011 for Mac