I have two columns - Name and value. When I want to SUM the range using SUM function, I get total sum. value.
But what I'd like to do is my total sum will be auto updated if I fill any cell with a color. In the example snippet (attached),
when I fill cell D12 with any color for example yellow...