Hello everyone, I have a column which is the result of a formula like:=IF(A2="ok",C2/D2,""), now say I want to calculate the average produced by that formula on a column, such as:
=AVERAGE(Formula column)I get that error. How can I solve this? Thank’s.
Somewhere in the Formula-Column is at least one #DIV/0-error ( a Division by zero), catch it!
Or there is no numeric value, for that AVERAGE() results in #DIV/0!. Or you are using column labels and literally typed =AVERAGE(Formula column) which is something else than the expected typo column name Forumula column that would need to be enclosed in single quotes anyway, like =AVERAGE('Forumula column') and without it tries to find an intersection of a column/row Formula and row/column column and if those happen to exist and the intersection cell contains no or 0 value then it’d also be a #DIV/0! error. But as you didn’t upload a sample these are all guesses.
@erAck @karolus indeed there was a #div/0 error. Thank’s for your help, sorry for opening a thread for this little oversight.
If indeed the cells may have erroneous and non-numerical values, then you can use the Aggregate function with the appropriate parameters.