Ignore formula errors
Anyway to ignore these errors so the AVERAGE of the column will show at the bottom? The formula to the right of the selected box is just a math equation, but that column also needs to ignore errors.
Thank you :)
Question marked as
Top-ranking reply
What is causing the error flag? Difficult to tell with the formula display sitting in front of cells that may be contributing to the error.
What is the error message you see when clicking (each) error flag?
Wrapping the formulas in IFERROR could be used to avoid the error message and replace the flag with a null string, leaving an apparently 'blank' cell, and, assuming the formula in column D is pulling values only from 'this row' and 'previous row' of column C, should not accect the results in rows currentlly not showing an error flag.
Syntax for IFERROR is pretty simple:
IFERROR(existingformula,"")
Regards,
Barry