Excel's checkbox tool helps you to manage ... will remain blank: =IFERROR(SUM([@[End Time]]-[@[Start Time]]),"") Again, once I press Enter, the formula will be applied to all rows in that column.

You can sum a series of numbers in Excel manually or automatically using the AutoSum tool in the ribbon. Both methods will always give you the same result, so you can use whichever one is more ...