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!
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
Opps, looks like it works!
Thank you!
Last edited by d7882; 09-17-2019 at 04:20 PM.
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.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks