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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I combine two functions AVERAGE and IF in Excel ? (https://www.excelbanter.com/excel-worksheet-functions/39420-how-do-i-combine-two-functions-average-if-excel.html)

onlineman

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

who knows ?

aristotle

Hi,

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

=AVERAGE(IF($A$1:$A$93,$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

"onlineman" wrote:

who knows ?

Andy Wiggins

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) )

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"onlineman" wrote in message
...
who knows ?

All times are GMT +1. The time now is 06:16 AM.