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.
Bookmarks