Help with sum formula

  • Thread starter Thread starter Jessica Walton
  • Start date Start date
J

Jessica Walton

Hey Gurus:

Need your expertese (again)! I'm trying to sum a column
that has a few #div/0! listings in it...the cells are
h5:h50 and there are two of those errors contained in that
range.

Any thoughts?
Jessica
 
Hi
try the following array formula (entered with CTRL+SHIFT+ENTER)
=SUM(IF(ISERROR(H5:H50),,H5:H50))
 
Jessica

adjust the formula in the column to remove the #DIV/0! errors

=IF(ISERROR(your formula),"",your formula)

Modify the first one then drag down if all the formulas are the same

Regards

Trevor
 
You can try

=SUM(IF(ISNUMBER(A1:A100),A1:A100))

entered with CTRL SHIFT ENTER, so it will have { } around it automatically
when entered correctly.

It just sums up the numbers in A1:A100 and doesn't bother with the errors.
 
Back
Top