Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do I ignore cells with #N/A in a function?

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?