A | B | C | D | E | |
1 | 21% | 20% | |||
2 | 14% | ||||
3 | 31% | ||||
4 | 7% | ||||
5 | 12% |
<tbody>
</tbody>
For Example: If the conditional formatting rule says A1>=$D$1 (than fill green). This would apply to all cells in column A. In this example cell E1 will show 52% (21%+31%).(unfortunately this page won't let me fill in cells)
What I'm trying to have in cell E1 is the sum of all qualifying cell (green cell) from column A.
As I chose to change the percentage in cell D1, E1 may also change as cells in column A may loss or gain qualifiers. For example if I change D1 from 20% to 10% than cell E1 will change from 52% to 78% (21%+14%+31%+12%).
How can I formulate E1 to sum all color filled cells in column A?
I know I can accomplish what I want in cell E1 by going column B1 and input =if(A1>=$D$1,A1,"") and drag the formula down the column and then going to E1 and input = sum(B1:B5). However I want to have E1 calculated by the qualifiers in the conditional format.