Solved

# Excel Averageifs

Posted on 2016-10-19
23 Views
Is it possible to use an OR condition in excel averageifs?  If so, can someone please demonstrate an example for me?

Thanks..
0
Question by:fb1990

LVL 47

Accepted Solution

Wayne Taylor (webtubbs) earned 500 total points
Not with AVERAGEIFS, but you can Array enter an AVERAGE function to provide an OR test...

=AVERAGE(IF((A1:A20="data2")+(A1:A20="data4"), B1:B20))
AVERAGEOR.xlsx
0

LVL 1

Author Closing Comment

Thank you very much.  Is there a non array formula that can be used?  Otherwise it worked for me.
0

## Featured Post

### Suggested Solutions

A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.