Thread: Average if
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Average if
=SUMPRODUCT(F1:F100,--(G1:G100="5085-18/8 S"))/COUNTIF(G1:G100,"5085-18/8 S")

--
Gary''s Student - gsnu200787


"Renee" wrote:

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?
Reply With QuoteReply With Quote