AVERAGEIF question

[benmcdermott]

Hi all,
I am encountering some issues with my averageif calculation.

Current code is =AVERAGEIF('Suburb Dataset'!A2:A103,Legend!A2,'Suburb Dataset'!K2:K103)

It is basically to work out the average cost for a house with the following parameters and I have multiple sheets to have drop-down lists and simplify data input

- Suburb dataset (sheet name): column A = suburb
- Legend (sheet name): column A = suburb name
- Suburb dataset (sheet name): column K = house price

This calculation seems to work and no issues. I am facing another issue where I can to add in another true value to consider the walkability of the house.
These are sourced in the 'Legend' sheet under column H with four data entries - very close, walkable, drive, and far. How would you go about including these? Happy to just consider two averages that include 'very close' and 'walkable'.

Thanks again everyone for your help
Ben

 

[pecoflyer]

Please post a sample sheet. Thx

 

[benmcdermott]

Sorry about that pecoflyer, I thought it attached! Thanks for your help

 

[pecoflyer]

Being lazy by nature I used a simple Pivot Table (took about 30 seconds) which allows you to analyze data any way you want
To provide for maximum flexibility, first make your Dataset an Excel Table and use that table as a source for your PT
Pivot Tables sound impressive at first, but they are really worth their while and there is a lot of information on the net

5 Reasons to Use an Excel Table as the Source of a Pivot Table

Learn why using an Excel Table as the source of a pivot table can save time and prevent errors.

www.excelcampus.com

 

[benmcdermott]

That is a very good point, thank you! I have used pivot tables in the past, but never enjoyed how they convert to graphs - I probably just need to play/practice more.

Thanks for your help pecoflyer

 

[pecoflyer]

As for charts, there are tons of sites on the Net
Perhaps https://www.contextures.com/excelpivotchartsourcedata.html