The data is in an Excel table calledtable.
Bycreating a proper Excel table, we make the formulas easier to read and write.
The summary table on the right is constructed by entering Excel times in the Start and End columns.
The logical criteria is exactly the same, the only difference is the first argument, calledsum_range.
This is the range that contains values to sum, which is the Duration column in the table shown.
COUNTIF can be used to count cells that…
