Forum Discussion
Solved
Need assist with formula
I have a list of registrations and want to count the number in each category (T, S) that occurs at every whole hour. If no registration at a certain time, it should fill inn "0". (Dataset is below) ...
See the attached version. It uses SUMPRODUCT, not COUNTIF.
One option is a pivottable - see the attached sample workbook.
I added an auxiliary column "Hour (rounded)" to the source data, and used that instead of the Hour column in the pivot table.
I changed the pivot table to tabular format, specified that it should have no subtotals and grand totals, and that labels should be repeated.
Not very familiar with pivot unfortunately, but thanks anyway!