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.
I used the HOUR and COUNTIF to get half way, but still need input on the code to summarize/ sum up the numbers each hour/ date. Please see the attached dataset
Any input is appreciated. Thanks again!
See the attached version. It uses SUMPRODUCT, not COUNTIF.
- Thank you, this solved it!