Average if

  • Thread starter Thread starter Renee
  • Start date Start date
R

Renee

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?
 
=SUMPRODUCT(F1:F100,--(G1:G100="5085-18/8 S"))/COUNTIF(G1:G100,"5085-18/8 S")
 
One way:

=SUMIF(F:F,"5085-18/8 s",G:G)/COUNTIF(F:F,"5085-18/8 s")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average if ... 15
Excel Issue with "Average" showing in Status Bar 2
Macro to add numbers in a text string 5
Average Question 2
Averaging the two most recent entries in a column 13
MAX AVERAGE MIN with additional criteria, ignoring blank cells 6
Average Formula Help 2
Average with multiple conditions 4

Back
Top