Here is a possible solution to your problem. For example if A1 is
greater than 0 then this formula would sum all the cells listed. If A1
is 0 or less then the result if "False".

=IF(A10,SUM(D1,D3,D5,D7,D9,D11,D13,D15,D17),"Fals e")

Hope it helps.

BTW. there is a limit to the number of cells you can use this way but I
can't remember how many it is.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=499168