![how to sum a column in excel with zeros how to sum a column in excel with zeros](https://i.ytimg.com/vi/j1u3NrQXjE4/maxresdefault.jpg)
So, once this is linked to a cell, use the conditional SUMIF function to SUM the expenses.
![how to sum a column in excel with zeros how to sum a column in excel with zeros](https://allthings.how/wp-content/uploads/2021/06/allthings.how-how-to-add-leading-zeros-in-excel-image-13.png)
The CheckBox in Excel simply has a status of TRUE (ticked) or FALSE (un-ticked). The rows where the grand total is zero are hidden, and the wayward city names disappear from each region. A CheckBox in Column C will determine the status of the expenses.
![how to sum a column in excel with zeros how to sum a column in excel with zeros](http://www.excel-exercise.com/wp-content/uploads/2014/09/Automatic_Calendar_13.png)