Help! Sum function !

[rsheppick]

=SUM(IF('Debt #1 Old'!L30<="0.00",'Debt #1 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #2 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #3 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #4 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #5 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #6 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #7 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #8 Old'!L30,""),IF('Debt #
Old'!L30<="0.00",'Debt #9 Old'!L30,""),IF('Debt #1
Old'!L30<="0.00",'Debt #10 Old'!L30,""),IF('Debt #1
Old'!L30<="0.00",'Debt #11 Old'!L30,""),IF('Debt #1
Old'!L30<="0.00",'Debt #12 Old'!L30,""),IF('Debt #1
Old'!L30<="0.00",'Debt #13 Old'!L30,""),'Debt #14 Old'!L30,'Debt #1
Old'!L30,'Debt #16 Old'!L30,IF('Debt #17 Old'!L30>="0.000","",""),'Deb
#18 Old'!L30,'Debt #19 Old'!L30)


If you notice in the above formula, I am trying to say if that cell i
less than zero or zero ( the value thats in the cell is #!VALUE
however, i need to say if it is ZERO or under or an ERROR to ignore i
and sip to the next formula.

Can anyone here help me with this

 

[Frank Kabel]

Hi
you have to use
=IF(ISNUMBER(cell_reference) to check for a valid number. Also you may
try to avoid the error in these cells

 

[rsheppick]

*Hi
you have to use
=IF(ISNUMBER(cell_reference) to check for a valid number. Also yo
may
try to avoid the error in these cells

*[/QUOTE]

I don't think that will work, I need to include it in the abov
formula, if I have the way you said it says INVALI