Excel 2010 AVERAGEIF function to average two different columns on two different tabs

Hi All!

I currently have the following Formula:

=IFERROR(AVERAGEIF('Property Openings'!$E:$E,A12,'Property Openings'!$H:$H),0)

Now it works great but we have decided to include a second column in order to determine the average. This column is on the 'Property Filled' tab and the table is exactly the same, column E is still the 'IF' based on cell A12 and column H includes the numbers to be averaged. I tried the following formula but it did not work:

=IFERROR(AVERAGEIF('Property Openings'!$E:$E,A12,('Property Openings'!$H:$H,'Property Filled'!H:H)),0)

How can I make this work? Thank you for any assistance provided.

Sorry, just realized something I was missing thanks to your post. I want to average two different columns based on the criteria column on both tabs, not just based on the Property Openings tab.

Theoretically, I want to average the two averages below.

=IFERROR(AVERAGEIF('Property Openings'!$E:$E,A12,'Property Openings'!$H:$H),0)
=IFERROR(AVERAGEIF('Property Filled'!$E:$E,A12,'Property Filled'!$H:$H),0)

Originally Posted by daddylonglegs

OK, but a similar approach is still required, i.e.

=IFERROR((SUMIF('Property Openings'!$E:$E,A12,'Property Openings'!$H:$H)+SUMIF('Property Filled'!$E:$E,A12,'Property Filled'!$H:$H))/(COUNTIF('Property Openings'!$E:$E,A12)+COUNTIF('Property Filled'!$E:$E,A12)),0)

Worked perfectly! I truly appreciate the assistance.