In this article:

SUMIF by Color in Google Sheets (Easiest Way in 2024)

October 1, 2024

In this tutorial, we will show you exactly how to use SUMIF by color in Google Sheets with colored cells in just a few steps. Simply follow the steps below.

sumif color google sheets

SUMIF by Cell Color in Google Sheets

The SUMIF function in Google Sheets adds up the values in a range that meet specific criteria. It allows you to selectively sum data based on conditions you define.

Syntax

Here's the general syntax for using a SUMIF to cells with colored backgrounds:

```=SUMIF(range, criteria, [sum_range])```

Where:

range is the range of cells to check against the criteria.

criteria is the condition or value that determines which cells are included in the sum.

sum_range (optional) is the actual cells to sum if the criteria are met. If not specified, the function sums the cells in the range.

Use SUMIF on Cells with Background Color in Google Sheets

Follow the process below to use SUMIF by color in Google Sheets.

1. Identify the Cells You Want to Sum by Color

Look at your data column and find the cells that are colored (e.g., red). These are the cells you will sum.

google sheets sumif cell color

2. Create a Helper Column Next to Your Data

Next to your data column, create a helper column. This will be used to mark the cells you want to sum based on their color.

google sheets sumif background color

3. Label Each Row in the Helper Column Based on Color

In the helper column, add labels like “red” for rows where the corresponding cell in the data column is red. Only label the rows that match the color you're summing.

For example, if your data is in column A, write "red" in column B next to the red-colored cells.

google sheets add using sumif colored cells

4. Use the SUMIF Formula to Sum Based on the Helper Column

In the cell where you want the sum, use this SUMIF formula:

```=SUMIF(B2:B6, "red", A2:A6)```

The helper column (B2:B6) contains your labels (e.g., "red") while the data column (A2:A6) contains the values you want to sum.

5. Verify the Summed Total for Correctness

Check the result to ensure that only the values from the cells labeled "red" in the helper column are summed. In our example, the sum of the two red-colored cells is 1136 which is the same if we manually typed the values in a calculator.

We hope that you now have a better understanding of using the SUMIF function to colored cells on Google Sheets. If you enjoyed this article, you might want to check our articles on how to color cells in Google Sheets using hex values and how to make a supply and demand graph in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->