Excel do not display 0 if the cell value is 0
=IF(A2=0,””,SUM(A2:A5))
=IF(A2=0,””,SUM(A2:A5))
> There are a number of ways to insert a SUM() function into an Excel spreadsheet. The hard way is to enter the entire function manually. That method is prone to mistakes because you must know the cell references and then enter them correctly. If you like, you can enter =SUM( manually, highlight the range …
>=IF(A2=0,””,SUM(A2:A5))
=IF(A2=0,””,SUM(A2:A5))