Try the below

=SUMPRODUCT(
($FP$10:$FP$89={"W","SA","SA+","ST"})*
($GE$10:$GE$89={"4c","4c+","4b","4b+","4a","4a+"," 5c","5c+","5b","5b+","5a","5a+","6c"}))
/SUMPRODUCT(($FP$10:$FP$89={"W","SA","SA+","ST"})*( $GE$10:$GE$890))

If this post helps click Yes
---------------
Jacob Skaria


"Romileyrunner1" wrote:

Hi, HAVING ERROR MESSAGES WITH THE FOLLOWING FORMULA.
iF i USE A SINGLE VARIABLE IN COLLUMN fp SUCH AS "w", THEN ALL IS FINE. iT
CAN`T SEEM TO RETRIEVE 4 DIFFERENT VALUES WHILST ALSO LOOKING ACROSS FOR THE
RANGE OF VALUES IN COLLUMN ge.
aNY IDEAS ????
tHANKS
rr1

=SUMPRODUCT(($FP$10:$FP$89={"W","SA","SA+","ST"})* ($GE$10:$GE$89={"4c","4c+","4b","4b+","4a","4a+"," 5c","5c+","5b","5b+","5a","5a+","6c"}))/SUMPRODUCT(($FP$10:$FP$89={"W","SA","SA+","ST"})*( $GE$10:$GE$890)))