![]() There’s no straightforward way to sum cells based on background color in Excel. Sample data to sum cells based on background color We enter the results in cells G3 and G4.įigure 2. We want to determine the sum of the orders based on the background color. ![]() Note that Product ID and Orders have preset background colors yellow and green.Ĭells F3 and F4 contain the two background colors yellow and green, which will serve as our criteria. ![]() Our table has three columns: Product ID (column B), Orders (column C) and a helper column Background Color (column D). Sum_range : the cells that will be added if left blank, “sum_range” = “range” which means that the range of data that will be added is the same range of data evaluated.Criteria : the criteria or condition that determines which cells will be added.Range : the data range that we will evaluate using the criteria.SUMIF sums the values in a specified range, based on one given criteria Final result: Using SUMIF to sum cells based on background colorįinal formula: =SUMIF($D$3:$D$8,F3,$C$3:$C$8) Syntax of the SUMIF Function ![]() This step by step tutorial will assist all levels of Excel users in summing values in cells based on background color.įigure 1. While working with Excel, we are able to sum values that satisfy a given criteria by using the SUMIF function. How to Use SUMIF to Sum Cells Based on Background Color ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |