Incidentally I tried (without success) the following rather shorter solution
to test for positive values. Any responses to why it fails would extend my
understanding one more iota and would be appreciated:

{=SUM(IF(NOT(ISERROR(N(INDIRECT("'Debt #" & ROW(INDIRECT("$1:$19")) & "
Old'!L30")))),MAX(0,N(INDIRECT("'Debt #" & ROW(INDIRECT("$1:$19")) & "
Old'!L30")))))}

--
Return email address is not as DEEP as it appears
"Jack Schitt" wrote in message
...
Further to my last post, I hadn't noticed that you also wanted it to sum
only positive values. Easily adapted:

Array entered:

=SUM(IF(NOT(ISERROR(N(INDIRECT("'Debt #" & ROW(INDIRECT("$1:$19")) & "
Old'!L30")))),N(INDIRECT("'Debt #" & ROW(INDIRECT("$1:$19")) & "
Old'!L30"))*(N(INDIRECT("'Debt #" & ROW(INDIRECT("$1:$19")) & "
Old'!L30"))0)))

--
Return email address is not as DEEP as it appears
"rsheppick " wrote in message
...
Yes,

That is the problem the #Value is because some of the sheets that I
wish to add have that as the restult in the square I am trying to =sum

I am trying to find a formula that will allow me to use the previous
noted forumla but say if it =error or=<=0.00 then ignore it and
contiune on until the end.

Understand what I am saying lol


---
Message posted from http://www.ExcelForum.com/