G
Guest
I have a set of 4 columns of data that are all the result of a different
division formula corresponding to each column. Many of the entries are a
#DIV/0! entry.
I would like to take a single average of all the actual numeric entries in
the entire set of columns that were greater than zero (0) and less than ten
(10) in value. How would you suggest I proceed?
division formula corresponding to each column. Many of the entries are a
#DIV/0! entry.
I would like to take a single average of all the actual numeric entries in
the entire set of columns that were greater than zero (0) and less than ten
(10) in value. How would you suggest I proceed?