I have thousands of rows of which a number contain #N/A. Running functions such as SUM or AVERAGE report an error when selecting a row sample that includes cells with #N/A. It’s time consuming to remove these lines individually. Furthermore, I prefer to keep them for transparency reasons.
Is there any way to ignore these cells?