LinkBack URL
About LinkBacks
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?
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?
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.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi sambo
in cell BN5 is the formula
if you have any questions please feel free to ask
much appreciated
for the formula you presented you had the average backward, it should be this ... =AVERAGEIF(F4:F43,"D",BM4:BM43)
Hi, Try this.
=AVERAGEIF($F$4:$F$43,"D",$BM$4:$BM$43)
☚ Click ★ just below left if it helps, Boo?ath?
doh
omg sambo
sort of sums me up backward.
thank you buddy
You're welcome. Glad I could help.
thank you
didnt see this till now
Thank you for the rep!
Last edited by Sam Capricci; 10-07-2019 at 06:37 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks