If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#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. |
#2
|
|||
|
|||
#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. |
#3
|
|||
|
|||
#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. |
Thread Tools | |
Display Modes | |
|
|