Hello,
In range (B2: F10) have numbers. In column G we mean the sum of the rows in G2 = SUM (A2: F2) in G3 = SUM (A3: F3), etc.
In B11 = AVERAGE (B2: B10) in C11 = AVERAGE (C2: C10) etc.
If C4 fill it with a color I would like the amount of G4 to decrease with cell value and vice versa if you get normal color in cell the sum of column G to modify with the cell value. The same for AVERAGE of the line 11.
For example say in C4=10 and sum in G4=100, if I change color of cell C4, sum in G4 will be 90, if I remove color of C4, G4 will be 100.
In same way for AVERAGE in row 11
Thanks.