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 Formula Helper

Use Built-In Advanced Formulas In Excel You can quickly use built-in formulas without writing them…

Excel Advanced Functions

Use Built-In Advanced Functions In Excel You can quickly use built-in functions without writing VBA…

Excel Count Words

Count Words of Selected Cells In Excel Count words in a cell or in a…


Scroll to Top