VLOOKUP inside an AVERAGEIFS

Hi, guys!
Help me please!
How to find average number of days all employees worked in the company by locations and seniority?
I've tried by using AVERAGEIFS&VLOOKUP, but nothing right...
Location Seniority Start Date Termination Date
Krakow Regular 24-Feb-16 24-Feb-17
Kyiv Regular 24-Feb-16 17-Mar-17
Bucharest Junior 23-Feb-16 1-May-17
London Regular 23-Feb-16 31-May-17

I would convert your range to a table, then use this in C6:

=IFERROR(AVERAGE(IF((Table1[Location]=$B6)*(Table1[Seniority]=C$5),Table1[Termination Date]-Table1[Start Date])),"") Ctrl Shift Enter

Thanks for the reply!
It's still doesn't work...Screenshot_1.png

You have to enter the formula using Ctrl Shift Enter instead of just Enter.

This part is important which is why I made it bold in post #2.

Also, you made changes to the formula that will make it not work.