I am using this formula to average a range but it returns a division by zero error.
AVERAGE(IF('2017'!$B$3:$B$150=A37,'2017'!$D$3:$D$150))) A 37 is a cell reference with text in it.
PLEASE HELP ME FIGURE THIS OUT ANYONE THANKS!!!!
I am using this formula to average a range but it returns a division by zero error.
AVERAGE(IF('2017'!$B$3:$B$150=A37,'2017'!$D$3:$D$150))) A 37 is a cell reference with text in it.
PLEASE HELP ME FIGURE THIS OUT ANYONE THANKS!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks