Averageifs month and 3 more conditions

[pedroccamara]

Hi guys,
I'm a litle stucked in here. I have this formula:

AVERAGEIFS([Un Price],[Entity],[@Entity],[Item],[@Item])

Which gives me the average price by Entity and item but i would like to add the month, because the next month it could be a different value and i wanna compare later with other suppliers (entity).

The point is: i have to know for each item code, who's giving me the best price. But i also wanna know, the max, min and avg for each item, by entity of course.
I believe this the way to start, by that formula above, right?
I'm very open to any ideas.
Thank you very much to you all.
Best regards
Pedro

 

[Aladin Akyurek]

Try to post a sample along with the desired results which must obtain for that sample.