[Averageifs] Alternative with multiple criterias in multiple columns

Lolo1313

New Member
Joined
Jun 2, 2021
Messages
11
Office Version
  1. 2016
Platform
  1. Windows
Hi everyone

I'm trying to make use of Averageifs with multiple criterias in multiple columns. But from what I have read so far in the forum, it's not the right function to get where I want to

I've found the following post: AVERAGEIFS with multiple criteria on one range In which T. Valko proposes =IFERROR(AVERAGE(IF(ISNUMBER(MATCH(Data!O2:O2000,S2:T2,0)),Data!Q2:Q2000)),0) for a search in one column with different criterias:.

I sadly cannot make it work for my sheet/problem and would appreciate any help :)
Let me explain what I'm trying to do

My main sheet looks as follows:
1624692883204.png


I want to get the average number out of all the data found in Column L , for all the "Material" in column A that matches the data from another sheet (see below) and a specific arguement from Column E (eg. " L-PHOT1").

My second sheet:
1624694093124.png


The Average number ought to be shown on a 3rd sheet that I use as a dashboard.

I hope that it is understandable... Let me know if more information is needed
Thank you for your help!
 
You're welcome & thanks for the feedback.
 
Upvote 0

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top