Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum numbers only when a named cell is not zero
In my spreadsheet, I need cell L10 to sum cells ( M10-P10) if P10 does not
equal zero. P10 is a formula=+n10+O10. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
One way:
=IF(P10<0,SUM(M10:P10),"") Given P10's formula, it could also be =IF(P10<0, 2*P10+M10,"") or, if you want to return 0 instead of a null string: =(P10<0)*(2*P10+M10) Note that the first "+" in your formula is superfluous. In article , "Cheryl McHarg" <Cheryl 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbers being entered show in formula bar but not in cell? | Excel Discussion (Misc queries) | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Named Cell Ranges | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |