Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Change your sum and average formulas to include error checking using the iserror or isna functions. Something like this will check for errors, then do your calculation:

=IF(ISNA(A5), 0, SUM(A5))

If there is an error, the result will be 0 and your further column functions will work properly.