=SUM('Debt #1 Old'!L30,'Debt #2 Old'!L30,'Debt #3 Old'!L30,'Debt #
Old'!L30,'Debt #5 Old'!L30,'Debt #6 Old'!L30,'Debt #7 Old'!L30,'Debt #
Old'!L30,'Debt #9 Old'!L30,'Debt #10 Old'!L30,'Debt #11 Old'!L30,'Deb
#12 Old'!L30,'Debt #13 Old'!L30,'Debt #14 Old'!L30,'Debt #1
Old'!L30,'Debt #16 Old'!L30,'Debt #17 Old'!L30,'Debt #18 Old'!L30,'Deb
#19 Old'!L30)
The above is all of the cells I need added together. Some of them hav
nothing in them so I get #VALUE! back for the aboves answer. What woul
be an easy way to tell it to ignore anything that isn't a number grate
than zero?
Thanks.
Ronni
--
Message posted from
http://www.ExcelForum.com