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!
