# Averageif with multiple criteria

1. ## Averageif with multiple criteria

Hey guys, hoping you could help me out.

I'm trying to create a formula that would take the average of a column based on 3 criteria. I've attached my file and my poor attempt at it but looks like I need outside help.

For example, want to find the average time worked based on criteria; Jan 2017 (date), Office Associate (Title), and Active or Fired (Status).

Thank you for your help everyone!

2. ## Re: Averageif with multiple criteria

J3=IFERROR(AVERAGEIFS(\$E\$2:\$E\$297,\$B\$2:\$B\$297,\$H3,\$C\$2:\$C\$297,\$I3,\$A\$2:\$A\$297,J\$2),"")

copy across and down

3. ## Re: Averageif with multiple criteria

Opps, looks like it works!

Thank you!

4. ## Re: Averageif with multiple criteria

Hi -

You want to use the AVERAGEIFS() formula for multiple criteria. Your formula would look like this:

=IFERROR(AVERAGEIFS(\$E\$2:\$E\$297,\$A\$2:\$A\$297,J\$2,\$B\$2:\$B\$297,\$H3,\$C\$2:\$C\$297,\$I3),"N/A")

Note some of the combinations of criteria have no data, so they end up returning a DIV/0! error. To get rid of that, I enclosed the formula in an IFERROR()

Hope this helps.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1