How to easily count and sum colored cells in Excel for Mac

Count & Sum by Color app for Excel 2011 (Mac)

Count & Sum by Color is a nifty app for Mac that quickly calculates cells by the color of background or font. From this help page, you'll learn how to use the All Colors and One Color tabs on the app's pane to sum or count highlighted cells, as well as find average, min and max values based on the color code. Below you'll also find how to paste the calculation results to any location in your table.

How to work with the All Colors tab

Count & Sum by Color app will become your reliable assistant in adding or counting cell values grouped by colors. If you are fond of using different color codes to highlight certain parts of data, this helpful app will show you Sum, Count, Average, Min or Max for the colored cells.

1. If you need to sum or count all highlighted cells in Excel 2011, first open the worksheet with your data and run the Count & Sum by Color app by clicking on its name under the Ablebits.com tab.

Clicking on Count and Sum by Color name under the Ablebits.com tab

2. You'll see the Count & Sum by Color pane open. Click on the All Colors tab.

Click on the All Colors tab

3. Highlight the needed range in your table and you will see its address in the Select range field.

Highlight a range to see its address in the Select range field

It's also possible to click on the Select range button to pick the necessary area manually.

Click on the Select range icon to pick the necessary area manually

4. Now you can specify the color option by selecting the Background or Font radio button.

Specify the color option by selecting the Background or Font radio button
  • Press the Background radio button to calculate by the color of cells.
  • Select the Font radio button to process the selected values by their text color.

5. Press the Calculate button to process the range.

Click on the Calculate button

The results will be displayed on the Count & Sum by Color pane grouped by color codes.

See the results on the app's pane grouped by colors

6. The app will quickly perform all math operations on your data. You can then pick any function from the Show results for drop-down list to see the needed calculation results.

Pick any function from the Show results for drop-down list
  • Sum – add all the cell values.
  • Count – count the number of cells.
  • Average – determine the average of the values.
  • Min – see the highest number.
  • Max – show the lowest cell value.

7. This handy calculating tool also lets you paste the results from the app's pane to any location on your spreadsheet.

Click on the Paste results… button to see the Ablebits.com Count & Sum by Color dialog box.

Click on the Paste results… button See the Count & Sum by Color dialog box

Select any cell in your current or new worksheet for adding the numbers and click OK to see the calculation results added.

See the calculation results added

How to work with the One Color tab

If you use multiple different colors to group and highlight data in your Excel 2011 tables, you may need to pick certain color and use it to calculate cell values. The One Color tab on the Count & Sum by Color pane lets you instantly calculate cell data based on the color you select.

1. Open the Excel table where you need to calculate cell values and run the Count & Sum by Color app by clicking on its name under the Ablebits.com tab.

Clicking on Count and Sum by Color name under the Ablebits.com tab

2. Click on the One Color tab to start.

Click on the One Color tab

3. Select the range in your table and you will see its address in the Select range field.

Highlight a range to see its address in the Select range field

You can also click on the Select range button to pick the necessary range manually.

Click on the Select range icon to pick the necessary area manually

4. Now you need to specify the correct color by choosing the cell that contains the necessary fill or font in your table. To do this, click on the Select range button next to the Pattern cell field.

Click on the Select range icon next to the Pattern cell field

You'll get the Ablebits.com Count & Sum by Color dialog box letting you select a pattern cell with the right color.

Select a cell with the right color

The address of the selected cell will automatically appear in the Pattern cell field.

5. Define if you want to use the background or font color for calculation.

Specify the color option by selecting the Background or Font radio button
  • Click the Background radio button to count the selected data by the fill color.
  • Select Font if it’s the text color you want to use.

6. Finally press the Calculate button.

Click on the Calculate button

On the add-in pane you'll instantly see Sum, Count, Average, Min and Max calculated for the cell data of the specified color.

See Sum, Count, Average, Min and Max calculated for the cells of the specified color

7. If you want to paste the results to your table, just click on the Paste results… button.

Click on the Paste results… button

You'll get the Ablebits.com Count & Sum by Color dialog box letting you pick the top left cell for pasting the calculations. Just click on the needed cell and click OK on the dialog box.

See the Count & Sum by Color dialog box

Feel free to use the One Color tab each time you need to see the results just for the color you specify.

The Count & Sum by Color app will save you much time on calculating and recalculating highlighted data in your Excel for Mac. Besides summing and counting values in the colored cells, it also allows applying Average, Max or Min functions to the highlighted range. Choose this tool for quick and reliable color calculations.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish your message on our support forum
 

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard
 
 
Excel add-ins and Outlook tools - Ablebits.com