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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks