Sum and count cells by color in Excel 2016 - 2007

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.

Learn more
This tool is part of
Ultimate Suite
Count & Sum by Color for Excel 2016 - 2007

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.
  • Calcuate 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.
  • 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.

How to count cells by color in Excel

  
Sum and count cells by all background colors
Sum and count cells by all background colors
Count and sum cells, find average, maximum and minimum by all font colors
Count and sum cells, find average, maximum and minimum by all font colors
Sum and count cells by the chosen background color
Sum and count cells by the chosen background color
Count and sum cells, find average, maximum and minimum by the chosen font color
Count and sum cells, find average, maximum and minimum by the chosen font color
Sum and count cells by all background colors
Count and sum cells, find average, maximum and minimum by all font colors
Sum and count cells by the chosen background color
Count and sum cells, find average, maximum and minimum by the chosen font color

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Count & Sum by Color for Excel

Supported versions

 

Excel

  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • Windows Vista
  • Windows XP
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.
Excel add-ins and Outlook tools - Ablebits.com