There's a smarter way to sum your spreadsheet totals, and it starts with how you use conditional formatting. The user who posted this question is trying to sum only the dark green cells, cells that turn green when a separate progress formula returns "TRUE." It's a fair question, but it also reveals a common misconception: conditional formatting is a visual tool, not a data type. You can't sum colors directly, and you shouldn't try to. What you can do is sum the logic behind the color.
The real solution is to move the condition out of the formatting rule and into a helper column. If the green color appears because a progress threshold is met, that same threshold can be written as a simple `IF` or `SUMIF` formula. For example, if column A holds amounts and column B holds progress values, you could use `=SUMIF(B:B, "TRUE", A:A)`, but only if the "TRUE" value exists as text in a cell. If the progress is calculated on the fly, you can replicate that calculation inside a `SUMIFS` or `SUMPRODUCT` formula. The point is this: your spreadsheet already knows why a cell is green. You just need to ask it in a language it can compute.
This matters because relying on color to drive calculations creates fragile workflows. What happens when someone changes the formatting rule, or the color scale shifts slightly? Your totals break silently. By basing your sum on the underlying condition, not the visual cue, you build a spreadsheet that's transparent, auditable, and resilient. You also make it easier for collaborators to understand what's being totaled and why. That's the difference between a sheet that merely looks organized and one that's truly well-designed.
So here's the concrete move: identify the exact condition that triggers the green fill, then write a formula that references that condition directly. If the condition is "progress equals or exceeds 100%," use `=SUMIFS(amount_range, progress_range, ">=1")`, assuming progress is stored as a decimal or percentage. If it's a text flag like "TRUE," make sure that flag exists in a cell, not just in the formatting rule. Then your sum becomes dynamic, accurate, and independent of any color scheme. That's not just a fix for this user's question; it's a better habit for anyone who wants their data to do more than look pretty.