# Average

#### sandejos

##### New Member
Hi ,
Please help what is the formula to find the average between to numbers. e,g I have a one column and i have to find out the average of diff ranges like 0-50 , 51-200, 201-1000,1001-5000

ColumnA
2
50
100
3
101
496
395
35
60
758
892
44
154
79
2000
359
25
1396

Regards,
Sandeep Joshi

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
Welcome to the Board!

You should be able to do this with the AVERAGEIFS formula. See: MS Excel: AVERAGEIFS Function (WS)

So, let's say that your data was in the Range A1:A18. To find the average of the values between 0 and 50, your formula would look like this:
Code:
``=AVERAGEIFS(A1:A18,A1:A18,">=0",A1:A18,"<=50")``
Then just repeat for the other ranges, changing the hard-coded values in each formula.

Replies
1
Views
189
Replies
4
Views
1K
Replies
1
Views
238
Replies
6
Views
670
Replies
3
Views
224

1,196,188
Messages
6,013,927
Members
441,796
Latest member
kmag

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