Cheryl,

try

=if($P$10<0,sum(M10:P10),"")

or

=if($P$10<0,sum(M10:P10),0)

to reflect a zero.


Cheryl McHarg Wrote:
In my spreadsheet, I need cell L10 to sum cells ( M10-P10) if P10 does
not
equal zero. P10 is a formula=+n10+O10.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=399694