Assign a number for each background color For this example, the key is to assign a value for each background color, and use that value as the criteria for our SUMIF function. 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).
![how to sum a column in excel based on month how to sum a column in excel based on month](https://i0.wp.com/www.auditexcel.co.za/wp-content/uploads/2015/02/Formula-Auditing-Trace-Precedent-4-500x205.jpg)
While working with Excel, we are able to sum values that satisfy a given criteria by using the SUMIF function.
![how to sum a column in excel based on month how to sum a column in excel based on month](https://images.squarespace-cdn.com/content/v1/585cfe2029687faf3fb612d4/1528992662461-9CMW1HFO32BKRLPWRVME/excel-formula-l12m-total-match-column-visually-explained.png)
HOW TO SUM A COLUMN IN EXCEL BASED ON MONTH HOW TO
How to Use SUMIF to Sum Cells Based on Background Color