How To Sum And Count Cells By Color In Excel

Sum and count and average cells by color in Excel

Excel How to Remove Text Only Or Numbers Only

To make the data stand out more in Excel, we always format the cells with a filling color or font color. Counting or summing cells based on the color of the background or font is also necessary occasionally. In other words, calculating sum and count and average and maximum and minimum of the cells that share the same color. Regretfully, we are unable to complete this task in Excel directly. However, Dose for Excel’s Count by Color will help to quickly and simply solve this issue.

Click DOSE » Format » Count by Color

Sum And Count Cells By Color In Excel

Sum and count by standard formatting background color

  1. Select range of cells that you want to count and sum its cells.
Sum and count by standard formatting background color
  1. Then select “Standard Formatting” from the “Color method” drop down list and select “Background” from the “Count type” drop down list. Then click Apply.
Sum and count by standard formatting background color

Sum and count by conditional formatting background color

  1. Select range of cells that you want to count and sum its cells.
Sum and count by conditional formatting background color
  1. Then select “Conditional Formatting” from the “Color method” drop down list and select “Background” from the “Count type” drop down list. Then click Apply.
Sum and count by conditional formatting background color

Sum and count by both standard and conditional formatting background color

  1. Select range of cells that you want to count and sum its cells.
Sum and count by both standard and conditional formatting background color
  1. Then select “Standard and Conditional formatting” from the “Color method” drop down list and select “Background” from the “Count type” drop down list. Then click Apply.
Sum and count by both standard and conditional formatting background color

Sum and count by standard formatting font color

  1. Select range of cells that you want to count and sum its cells.
Sum and count by standard formatting font color
  1. Then select “Standard formatting” from the “Color method” drop down list and select “Font” from the “Count type” drop down list. Then click Apply.
Sum and count by standard formatting font color

Sum and count by conditional formatting font color

  1. Select range of cells that you want to count and sum its cells.
Sum and count by conditional formatting font color
  1. Then select “Conditional formatting” from the “Color method” drop down list and select “Font” from the “Count type” drop down list. Then click Apply.
Sum and count by conditional formatting font color

Sum and count by both standard and conditional formatting font color

  1. Select range of cells that you want to count and sum its cells.
Sum and count by both standard and conditional formatting font color
  1. Then select “Standard and Conditional formatting” from the “Color method” drop down list and select “Font” from the “Count type” drop down list. Then click Apply.
Sum and count by both standard and conditional formatting font color

Generate a report of colors and their sum and count and others calculations

  1. Click on “Report” button and a report will be generated in a new worksheet.
Sum And Count Cells By Color In Excel


More Features:

Excel Split

In Excel, split the first and last word, or divide them by a delimiter or…

Excel Compare Sheets

Compare Sheets In Excel Comparing Excel sheets will take long time if doing it manually,…

Excel Color Duplicates

Color Duplicated Cells Values In Groups In Excel Color the duplicated cells values, each group…

Excel Insert Empty

Insert Empty Rows Or Columns At Certain Interval In Excel If you ever want to…

Excel Count Chars

Count Chars In Excel Count chars in a cell or in a selected range of…


Scroll to Top