# =AVERAGEIF formula error help

#### redspanna

##### Well-known Member
Hi all

I'm using the following formula to try and obtain an average of the values stored through AT2:AT86 if the value in AW1:AW86 is equal to 'September'

Code:
``=AVERAGEIF(AW1:AW86, "September", AT2:AT86)``

because the values stored through AW1:AW86 to get 'September' are Formulas I'm getting a #DIV/0 error

How to I get the formula above to work??

regards

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

#### AliGW

##### Banned
Sounds like the formulae are returning text that looks like numbers.

#### redspanna

##### Well-known Member
...ok and a work around to solve this??

thanks

#### AliGW

##### Banned
Hard to say. What is the formula you are using?

I will have a look at the file if you can upload it to DropBox or similar and provide a link (not all members can or will access file-sharing sites, however).

#### redspanna

##### Well-known Member
I've used a formula to put the required result into a 'TEXT' format like below
Code:
``=IF(ISBLANK(A2),"",TEXT(A2,"MMMM"))``
Then used my original formula above =AVERAGEIF(AW1:AW86, "September", AT2:AT86) and this has fixed the issue

many thanks and Happy Christmas to all

#### AliGW

##### Banned
Thanks for letting us know!

Replies
4
Views
572
Replies
2
Views
2K
Replies
4
Views
792
Replies
4
Views
988
Replies
3
Views
148

1,191,171
Messages
5,985,067
Members
439,938
Latest member
MAlhash

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