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...