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

#### Edw83088

##### New Member
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?

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

#### Michael M

##### Well-known Member
Maybe something like

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

#### Michael M

##### Well-known Member
Ooops, try for all

Excel 2007
ABCD
1100007900=AVERAGEIF(A1:A100,"<=10000",B1:B10)
22000017500=AVERAGEIFS(B2:B10,A2:A10,">10000",A2:A10,"<=20000")
33000021000=AVERAGEIFS(B2:B10,A2:A10,">20000",A2:A10,"<=30000")
4100003500
52000014500
63000027000
7100006800
82000012000
93000023500
10100003500
Sheet3

#### Edw83088

##### New Member
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

##### Well-known Member
You could list your states in a separate column ....say column "Z" and then use
and darg down as required
Code:
``=AVERAGEIF(\$A\$2:\$A\$495,Z1,\$C\$2:\$C\$495)``

Replies
1
Views
140
Replies
0
Views
249
Replies
1
Views
430
Replies
5
Views
147
Replies
4
Views
133

1,191,384
Messages
5,986,311
Members
440,017
Latest member
vasanrajeswaran

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back