This formula gives me the correct answer, but is there a way to simplify it so that I do not have to have 2 SUMPRODUCTS?
=+SUMPRODUCT((A10=Data!$A$2:$A$5000)*(F$3=Data!$L$2:$L$5000)*(Data!$E$2:$E$5000)*(Data!$F$2:$F$5000))/+SUMPRODUCT((A10=Data!$A$2:$A$5000)*(F$3=Data!$L$2:$L$5000)*(Data!$F$2:$F$5000))
Thanks
=SUMPRODUCT((A10=Data!$A$2
Thomas