I have a worksheet that I am attempting to obtain the average for Range("C1:C500"). Some cells in that range contain #N/A as a value due to a calculation for the cell (the same range being used for graphing). When I attempt to use =AVERAGE("C1:C500"), I receive #N/A as a result.

How do I obtain the average result?

Ugghhhh!


Thank you.