Averageifs Help.

[Thehomegroup]

Hey Guys,

I have had luck with the countifs function however the averageifs has got me stumped on this one.

Problem;
I need this to return an average list price of a home that sold between 2 dates,between 2 values, and keyword. Data is on a separate tab(not part of the problem).

Column A Column B
Status Asking Price
Closed List of home values

So I need to know what the average listing price is from 9/26/2016-3/26/2017 that is "Closed" and between 0 - 49999



I have am using this countifs to return my number count. (and it is working)
=countifs('MLS Data'!$A:$A,"Closed",'MLS Data'!$D:$D,">="&$C$17,'MLS Data'!$D:$D,"<="&$D$17,'MLS Data'!$B:$B,">=0",'MLS Data'!$B:$B,"<=49999")


Any help would be great.

[southward]

Hi,

I think that what you are asking for is achievable. However, I would need to see a sample of your file.
Recommend you upload a (sample/sanitized) working copy of your file.

Cheers

[daddylonglegs]

You should be able to use exactly the same syntax as the COUNTIFS for your AVERAGEIFS, except with an added range to average at the start, I assume you are averaging the price. Did you try this?

=AVERAGEIFS('MLS Data'!$B:$B,'MLS Data'!$A:$A,"Closed",'MLS Data'!$D:$D,">="&$C$17,'MLS Data'!$D:$D,"<="&$D$17,'MLS Data'!$B:$B,">=0",'MLS Data'!$B:$B,"<=49999")

[Thehomegroup]

THANK YOU. That worked flawlessly. I could not for the life of me figure out what I was doing wrong. Very happy I found this place.