| View previous topic :: View next topic |
| Author |
Message |
sallam
Power User
Joined: 03 Mar 2007
Posts: 65
|
 Posted: Sat Dec 27, 2008 3:36 am Post subject: how to not show a zero in SUM or SUMIF cell |
 |
|
When I use SUM or SUMIF, and the result of the formula is 0, a '0' shows up in the cell.
What if I want to keep the cell blank when the sum is 0, so that it adds numbers to the cell only when the result is more than 0? |
|
| Back to top |
|
 |
RickRandom
Super User
Joined: 27 Jan 2006
Posts: 1082
Location: UK
|
| Posted: Sat Dec 27, 2008 7:43 am Post subject: |
|
|
=IF(SUMIF(...)=0;"";SUMIF(...))
or via Tools, Options, you can set an option to not display zeros, but it applies to the whole file. |
|
| Back to top |
|
|
sallam
Power User
Joined: 03 Mar 2007
Posts: 65
|
| Posted: Sat Dec 27, 2008 2:50 pm Post subject: |
|
|
| Many thanks RickRandom for your precise info. |
|
| Back to top |
|
|
|
