Google Product Forums

How Do I Leave a Cell Blank without if Function if the Sum Formula I'm Using Returns 0?


Birjoo Mar 6, 2012 2:28 AM
Posted in group: Google Docs Help Forum

Categories: Sheets :

How Do I Leave a Cell Blank without if Function if the Sum Formula I'm Using Returns 0?
 
Bitmap Bitmap
Wheat Sugar Milk Total Tea Patato Tomato Cabbage Total Misc. Other Grand Total
                         7,199                 4,599                   2,768                 19,166                   2,772                   4,355                    3,665                     3,389               14,181                   1,191                      -   34538
                         8,381                 4,503                   1,545                 21,269                   2,185                   2,876                    2,020                            -                    7,081                   2,454                      -   30804
                         6,704                 2,321                   3,795                 22,535                   5,957                   5,084                    4,717                     7,510               23,268                   6,228                      -   52031
                               -                                   -         =N72+M72+L72+G72
                               -                                   -         <--- Here formula put as above but not showing
                               -                                   -