Count/Sum Cells By Fill or Font Color Using Function in Excel Office 365!!
Tags: countsumcellsbyfillo, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:29:47

---
title: Count/Sum Cells By Fill or Font Color Using Function in Excel Office 365!!
published: true
date: 2020-11-15 15:39:00 UTC
tags: CountSumCellsByFillo,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/count-sum-cells-by-fill-or-font-color-using-function-in-excel-office-365/
---

In this article, we are going to explore how to **Count/Sum Cells By Fill or Font Color Using Function in Excel Office 365** using **Kutools.** Let’s step into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Use COUNTBYCELLCOLOR Function:

This function will help you to count the number of cells by a certain fill color in Excel, let’s see how it works.

- Let’s consider the following example. You can see the data range which is formatted with some background colors, and we are going to **count the cells based on the filled colors**.
- You need to **select a cell** where you want to print the result.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-12.png)<figcaption id="caption-attachment-17070">Select a cell</figcaption>

- Go to the **Kutools Tab, select** the **Kutools Functions** option, **choose** the **Statistical & Math** option, then **select** the **COUNTBYCELLCOLOR** Function.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-11.png)<figcaption id="caption-attachment-17071">Kutools Tab</figcaption>

- Now, it will open the **Function Arguments Dialog Box**.
- **Reference –** You need to **select the example data range** using the browse button.
- **Color\_index\_nr –** In this option, you need to **select one color cell** that you want to count from the range.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-11.png)<figcaption id="caption-attachment-17074">Click the OK button</figcaption>

- Then, **click** the **OK** button. You can see that the number of cells with a specific color has been counted as shown in the below screenshot.
- You need to **repeat the above steps** to count other color cells.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-9.png)<figcaption id="caption-attachment-17075">Result</figcaption>

## COUNTBYFONTCOLOR Function:

If you want to count the number of cells by certain font color, do as follows.

- First, you need to **select the blank cell** where you want to place the result.

![Select a blank cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-7.png)<figcaption id="caption-attachment-17076">Select a blank cell</figcaption>

- Go to the **Kutools Tab, select** the **Kutools Functions** option, **choose** the **Statistical**  **& Math** option, then **choose** the **COUNTBYFONTCOLOR** Function.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-7.png)<figcaption id="caption-attachment-17077">Kutools Tab</figcaption>

- It will display the  **Function Arguments Dialog Box**.
- **Reference –** You need to **select the input range** using the given browse button.
- **Color\_index\_nr – ** In this section, you need to **select one cell** that contains the specific font color.

![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-5.png)<figcaption id="caption-attachment-17079">Function Arguments dialog box</figcaption>

- Finally, **hit** the **OK** button. you can see all the cells of the same font color have been counted and print the result as shown in the below image.
- **Repeat the above steps** to count the remaining cells based on specific font color.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-5.png)<figcaption id="caption-attachment-17078">Output</figcaption>

## Kutools Function: COUNTSHADES:

To count the number of cells which have been filled color, follow the below steps.

- You need to **click any cell** where you want to display the result.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-3.png)<figcaption id="caption-attachment-17080">Select a cell</figcaption>

- On the **Kutools Tab, select** the **Kutools Functions** option, **choose** the **Statistical**  **& Math** option, then **select** the **COUNTSHADES** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-3.png)<figcaption id="caption-attachment-17081">Kutools Tab</figcaption>

- Next, it will show you the **Function Arguments Dialog Box**.
- **Reference –** Select the input range where you want to count the colored cells.
- After that, **click** the **OK** button to close the dialog box.

![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-1.png)<figcaption id="caption-attachment-17082">Function Arguments dialog box</figcaption>

- Now, you can see all the colored cells have been counted and print the result in the specified cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-1.png)<figcaption id="caption-attachment-17083">Result</figcaption>

## SUMBYCELLCOLOR Function:

Using this function, you can easily sum cells by a certain fill color in Excel. To do this, you need to follow the below steps.

- You need to **select a blank cell** to display the result.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-1.png)<figcaption id="caption-attachment-17084">Select a cell</figcaption>

- Go to the **Kutools Tab, select** the **Kutools Functions** option, **choose** the **Statistical & Math** option, then **select** the **SUMBYCELLCOLOR** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-1.png)<figcaption id="caption-attachment-17085">Kutools Tab</figcaption>

- It will open the **Function Arguments Dialog Box**.
- **Reference – Select the input range** where you want to sum the colored cells.
- **Color\_index\_nr – ** You need to **select any one cell** that contains the filled color you want to sum cells based on.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15-1.png)<figcaption id="caption-attachment-17086">Click OK button</figcaption>

- Finally, **hit** the **OK** button. You can get the **SUM** value as shown in the below screenshot.
- You need to **repeat the above steps** to find the sum of remains cells with other filled colors.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/16.png)<figcaption id="caption-attachment-17087">Result</figcaption>

## Use SUMBYFONTCOLOR Function:

If you want to sum cells by certain font color, you need to apply this function.

- You need to **click on any cell** in which you want to print the result.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/17.png)<figcaption id="caption-attachment-17088">Select a cell</figcaption>

- On the **kutools Tab, select** the **Kutools Functions** option, **choose** the **statistical & Math** option, then **choose** the **SUMBYFONTCOLOR** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/18.png)<figcaption id="caption-attachment-17089">Kutools Tab</figcaption>

- Then, it will open the **Function Arguments Dialog Box**.
- **Reference – ** You need to **select the input range** using the given browse button.
- **Color\_index\_nr –** Here, you need to **select any one cell** to find a sum based on the font color.

![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/20.png)<figcaption id="caption-attachment-17091">Function Arguments dialog box</figcaption>

- At last, **click** the **OK** button to get the result as shown in the below image.
- Kindly, repeat the above steps to find the sum of other colors as you need.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/19.png)<figcaption id="caption-attachment-17090">Output</figcaption>

## Summary:

In the above article, you can clearly understand the steps to **Count/Sum Cells By Fill or Font Color Using Function in Excel Office 365** using **Kutools. ** Don’t forget to share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Select Multiple Items from the Drop-down Lists in Excel?](https://geekexcel.com/how-to-select-multiple-items-from-the-drop-down-lists-in-excel/)
- [Validate Email Addresses in a Column or a Range of Cells in Excel](https://geekexcel.com/how-to-validate-email-addresses-in-a-column-or-a-range-of-cells-in-excel/)