SUM Issue.. HELP

[Guest]

Need to get a total of a column but the column contains N/A until information
it typed then it gives you a number.. i need the numbers to add... ???

Example below

3 $1.46
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A
#N/A #N/A

need totals to say 3 and $1.46 ... NOT
#VALUE!
#N/A

 

[Guest]

One way:

=SUMIF(A1:A10,"<>#N/A")

But you may want to consider modifying the formulas that are causing the
#N/A errors so that they won't appear in the first place. Something like:

=IF(ISNA(YourFormula),"",YourFormula)

or maybe:

=IF(ISNA(YourFormula),"No Data",YourFormula)

Thus, if your formula results in #N/A, a blank "" or "No Data" would be
returned instead. Either of these options would not interfere with the SUM
function in your totals.

HTH,
Elkar

 

[Peo Sjoblom]

This variety ignores all type of errors


=SUMIF(A1:A10,"<0"&999^99)



--


Regards,


Peo Sjoblom

 

[Guest]

Thank YOU!!

One way:

=SUMIF(A1:A10,"<>#N/A")

But you may want to consider modifying the formulas that are causing the
#N/A errors so that they won't appear in the first place. Something like:

=IF(ISNA(YourFormula),"",YourFormula)

or maybe:

=IF(ISNA(YourFormula),"No Data",YourFormula)

Thus, if your formula results in #N/A, a blank "" or "No Data" would be
returned instead. Either of these options would not interfere with the SUM
function in your totals.

HTH,
Elkar

 

[Guest]

Thank you

This variety ignores all type of errors


=SUMIF(A1:A10,"<0"&999^99)



--


Regards,


Peo Sjoblom