# Conditional Average IF

#### James02

##### Board Regular
Hi,

I want to average the Returns if the value is below 12. I'm not getting correct value. This formula is giving me 9 but it should be 6.75?? Thank you!

AVERAGEIF(B11:B14,"<=12",A11:A14)

 Return Value 10% 10 5% 15 2% 8 15% 3

<tbody>
</tbody>

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
10 + 2 + 15 = 27.
27 / 3 = 9.

10 + 2 + 15 = 27.
27 / 3 = 9.
+1

If your expected result is 6.75, then that's not an average.
27/4 would yield 6.75
That formula would be
=SUMIF(B11:B14,"<=12",A11:A14)/COUNT(A11:A14)

Last edited:
Thank you, I screwed up my double-check formula. The formula I have is correct. The formula will not let me reference an outside cell. "<=15" works if I type 15 in, but if I have 15 be referenced to another cell it doesn't work???

Suppose the other cell is K3, then enter "<="&K3

Suppose the other cell is K3, then enter "<="&K3

Dude ur a genius! Thanks! I couldn't figure out that "<="& for nothing. I'm going to save that in my study file.

Replies
3
Views
226
Replies
13
Views
279
Replies
4
Views
242
Replies
16
Views
523
Replies
4
Views
152

1,203,521
Messages
6,055,883
Members
444,830
Latest member

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