SUM Issue.. HELP

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
This variety ignores all type of errors


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



--


Regards,


Peo Sjoblom
 
Thank YOU!!

Elkar said:
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
Click to expand...
 
Back
Top