Forum Discussion
Solved
Need help to find the right code/ function
I have a relatively large dataset with registrations (numbers) from a specific time, each hour for many months (just a small sample shown here). I want to sum up every number that is registered at e...
Working with your sample, I first put in row 1, the hours 0, 1, 2, 3, 4, 5, 6....etc
Then in Row 2 the following formula, referring to Row 1 for the hours
=SUM(FILTER($B2:$B71,HOUR($A2:$A71)=C1,0))
And that gets the totals for each hour. Here's a screen grab, but I've also attached the spreadsheet.
Working with your sample, I first put in row 1, the hours 0, 1, 2, 3, 4, 5, 6....etc
Then in Row 2 the following formula, referring to Row 1 for the hours
=SUM(FILTER($B2:$B71,HOUR($A2:$A71)=C1,0))
And that gets the totals for each hour. Here's a screen grab, but I've also attached the spreadsheet.
- Thank you very much, mathetes!
This solved my problem!!
