What it does
Sums numeric cells in the selected range that match the fill color of a reference cell.
- Where the result goes
- The result is written only to the cell you pick.
- Source data
- The source data is unchanged.
- Good to know
- Only real numbers are summed; text, numeric-looking text, dates and errors are ignored, and conditional-format colors are not detected.
Your data is processed on your own computer. Your Excel contents are never shared with AI services.