=AVERAGEIF formula error help

[redspanna]

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'

=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??

Thanks in advance

regards

 

[AliGW]

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

 

[redspanna]

...ok and a work around to solve this??
any thoughts please

thanks

 

[AliGW]

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]

I've used a formula to put the required result into a 'TEXT' format like below

=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]

Thanks for letting us know!