#N/A error messages
I am trying to sum a colume that has some cells with '#N/A'. The cell with
the total, displays a '#N/A' now. How can I have that cell display the total of the numbers entered when there are the errors in the sumed cells. Thanks. |
#N/A error messages
=SUM(IF(ISERROR(A1:A100),0,A1:A100))
an array formula. Must be entered with CNTRL-SHFT-ENTER rather than just the ENTER key. -- Gary''s Student - gsnu200800 "Loren Newton" wrote: I am trying to sum a colume that has some cells with '#N/A'. The cell with the total, displays a '#N/A' now. How can I have that cell display the total of the numbers entered when there are the errors in the sumed cells. Thanks. |
#N/A error messages
=SUMIF(A:A,"<"&99^99)
if you want to sum column A, entered normally -- Regards, Peo Sjoblom "Loren Newton" wrote in message ... I am trying to sum a colume that has some cells with '#N/A'. The cell with the total, displays a '#N/A' now. How can I have that cell display the total of the numbers entered when there are the errors in the sumed cells. Thanks. |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com