How do I combine two functions AVERAGE and IF in Excel ?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,

In this example I want to find the average of all values greater than 3.

=AVERAGE(IF($A$1:$A$9>3,$A$1:$A$9))

This has to be confirmed with Ctrl+Shift+Enter as it's an array formula, it
will automatically encapsulate the formula within curly brackets.

Regards,
A
 
Who knows ... what you want to achieve - only you!
It helps to give more information, but ...

... here's an example of how they can be combined:
=IF(AVERAGE(A1:A3)=3,AVERAGE(B1:B3),AVERAGE(C1:C3))
 
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 Function 2
Question about Combin function 3
Trying to find additional ranges outside of min, max, and average 2
Excel Average dates help 0
XL2000 - Average/If/And Functions 7
Average of Subtotals in Pivot Table 0
AVERAGE 7
Averaging two ranges on the same column (excluding zeros) 2

Back
Top