Average if

Renee · May 22, 2008

I am trying to find the average of column F if column g is equal to "5085-
18/8 S" how can i do this?

Gary''s Student · May 22, 2008

=SUMPRODUCT(F1:F100,--(G1:G100="5085-18/8 S"))/COUNTIF(G1:G100,"5085-18/8 S")

Dave Peterson · May 22, 2008

One way:

=SUMIF(F:F,"5085-18/8 s",G:G)/COUNTIF(F:F,"5085-18/8 s")