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.

Count & Sum by Color app pane in Excel for MAC

Sum and count cells in your worksheet by color

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.

Download from Mac App Store

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

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.

Download from Mac App Store

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

Featured customers featured customers
Contact us

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

Ultimate Suite 2018.5 for Excel
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
Sheila Blanchard
Excel add-ins and Outlook tools -