SUM Issue.. HELP

  • Thread starter Setting a Mileage Expense Report
  • Start date
S

Setting a Mileage Expense Report

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
 
E

Elkar

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
 
P

Peo Sjoblom

This variety ignores all type of errors


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



--


Regards,


Peo Sjoblom
 
S

Setting a Mileage Expense Report

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...
 
Top