Is there an AVERAGE IF function in Excel?

G

Guest

I trying to average one row if another row's value is true. I know there is a
sumif, and a countif, but couldn not find an averageif. If you could let me
know who to do this, that would be wonderful.

Thank you,
Eli
 
B

Bernie Deitrick

Eli,

Simply use SUMIF/COUNTIF using the same criteria.

HTH,
Bernie
MS Excel MVP
 
D

Don Guillett

Yes, it's an array formula which must be entered with ctrl+shift+enter,
something like.

=average(if(a1:a21="J",b1:b21)
 

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

Is there an AVERAGEIF function in excel? 5
Need MAX value if condition is met 4
Calculate average in intervals 1
A Percentile IF function 1
Excel File Size 9
averageif 1
Average function help 4
Average IF Function 3

Top