Need help finding an average bid based on a range of prices

[Edw83088]

Let's say in column A I have a list of homes ranging from 0-30k. In column B I have the bid I've submitted for each property. What formula could I use to find my average bid based on a specific list price range. So I would need my average bid for properties 0-10 k 10-20, 20-30 etc to display. Could someone give me a hand please?

 

[Michael M]

Maybe something like

=AVERAGEIF(A1:A100,"<=10000",B1:B10)
=AVERAGEIF(A1:A100,"<=20000",B1:B10)
=AVERAGEIF(A1:A100,"<=30000",B1:B10)

Change your ranges to suit

 

[Michael M]

Ooops, try for all

Excel 2007
	A	B	C	D
1	10000	7900		=AVERAGEIF(A1:A100,"<=10000",B1:B10)
2	20000	17500		=AVERAGEIFS(B2:B10,A2:A10,">10000",A2:A10,"<=20000")
3	30000	21000		=AVERAGEIFS(B2:B10,A2:A10,">20000",A2:A10,"<=30000")
4	10000	3500
5	20000	14500
6	30000	27000
7	10000	6800
8	20000	12000
9	30000	23500
10	10000	3500
Sheet3

 

[Edw83088]

This worked wonderfully. I posted another thread with the below question.. maybe you could help again?

I have a list of properties I've placed bids on and there are multiple properties per state in the sheet. I'm using the below formula to pull that information and it has worked nicely. The only issue is that I'm wanting to drag this formula down my list of states without having to manually type the criteria in for each state abbreviation. How can I drag this down or alter the formula so that I can gather it for every state easily?

=AVERAGEIF(A2:A495,"AL",C2:C495)

 

[Michael M]

You could list your states in a separate column ....say column "Z" and then use
and darg down as required

=AVERAGEIF($A$2:$A$495,Z1,$C$2:$C$495)