error in formula returning #div

[sdts]

hi guys

im using this formula

=AVERAGEIF(AA4:BL43,F4:F43="D")

only it returns #div/0

the formula should return the average of cells AA4 to BL43 if in cells F4 to F43 it contains a "D"

how can i get round this please?

[Sam Capricci]

in general when using an averageif you don't use the equal sign. it is more like this... =AVERAGEIF(AA4:BL43,F4:F43,"D")
But that will not work over a range. Maybe to get a better formula you can upload a workbook with sample data.

[sdts]

Hi sambo

in cell BN5 is the formula
if you have any questions please feel free to ask

much appreciated

[boopathiraja]

Hi, Try this.

=AVERAGEIF($F$4:$F$43,"D",$BM$4:$BM$43)

[sdts]

thank you
didnt see this till now

[Sam Capricci]

for the formula you presented you had the average backward, it should be this ... =AVERAGEIF(F4:F43,"D",BM4:BM43)

[sdts]

doh
omg sambo
sort of sums me up backward.
thank you buddy

[Sam Capricci]

You're welcome. Glad I could help.

[Sam Capricci]

Thank you for the rep!