Hi,

Is it possible to use the below formula, but for it to not include rows that a certain colour?


=SUMPRODUCT(--($H$2:$H$65536=2),--($Y$2:$Y$65536=7),$AA$2:$AA$65536)/100