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:
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:
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!
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:
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:
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!