# average one column if there is a 1, 2, or 3 in another column

#### blake246

##### New Member
So ive got a pretty basic question. Hopefully someone can help. This is what I have.

1 14
2 16
1 7
4 4
3 12

I need to average all the numbers with a 1, 2, or 3 next to them. The solution is 12.25

I cant seem to get the formula quite right. Any help would be great.

Thanks

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Hi, I just tried this function which works if the data is in column A and B:

=AVERAGEIFS(B1:B5,A1:A5,">=1",A1:A5,"<=3")

So ive got a pretty basic question. Hopefully someone can help. This is what I have.

1 14
2 16
1 7
4 4
3 12

I need to average all the numbers with a 1, 2, or 3 next to them. The solution is 12.25

I cant seem to get the formula quite right. Any help would be great.

Thanks

Replies
1
Views
91
Replies
6
Views
127
Replies
7
Views
361
Replies
0
Views
154
Replies
3
Views
164

1,207,424
Messages
6,078,448
Members
446,339
Latest member
keogata

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