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.
You can add a working column 'Round hour' next to your data
Then using HOUR function you can get the round (whole hours).
Then you can summarize the results with COUNTIF or pivot table
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!