Hi,
I have a dataset on property prices ranging from £40,000 to about £4,000,000, and price changes. I want to find the average of the price change variable for each £20k interval of the price variable. So, average price change for prices between £40,000 and £60,000, and then between £60,001 and £80,000, £80,001 and £100,000 all the way up to £4,000,000. Both variables are on a different sheet to where I am doing the calculation. I have attached a small sample so you can see the data.
As I have a lot of intervals within which to calculate the average price changes, is there a way to set up the AVERAGEIFS formula so that it can be dragged down to cover all the intervals? So far I have tried to use cell references as the criteria, but I get the #DIV/0! error, and the cell references for the criteria do not change when I drag the formula down. I have manually typed the criteria in as numbers, but this of course will not change as I drag the formula down.
Can anyone help me out with this? Thanks!
Bookmarks