Worked fine but.....

If I remove the red background or add more cells to the "red" list, the
calculations do not change, the total stay as it was.

eg =SUMPRODUCT(--(ColorIndex(B9:U11)=3))*14 returns the value 140 if I
make the background RED for the first 10 cells.

If I then change the background of any of these cells by removing the RED or
if I add additional "RED" cells, the total value is not changing.

Again, am I missing something here.

Thanks