Hi,

And since 9E9 9^9 and = 9,000,000,000 which is probably bigger than any
single thing you have to sum

=SUMIF(A:A,"<9E9")

Which is really just a shorter version of a previous example. You could
also range name the range A and enter <1E304" in a cell and name it E and
then your formula

=SUMIF(A,E)

Which is not infomative by is short.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Biff" wrote:

Is there a way that I can add a column that includes #DIV/0!

Biff