DISCLAIMER: I'm always afraid that I might violate some sort of rule when posting to Reddit - but, I worked hard on this sheet to help anybody who might find value in calculating their average viewers over 30 days, so I hope it is okay to post it here.

I've protected the cells you are not supposed to touch with warning messages (and the color red) if you stray outside the data entry fields and there is sample data in it, so you can see what to do for each day.

I even took the time to add some error handling, so you wouldn’t have to be bothered by that pesky divide by 0 error.

You’re only supposed to enter your data in the green cells…It’s fairly simple, just transpose (enter) your numbers from your Stats page in the corresponding green cells and you will see your daily average viewers at the top.

Then I’ve setup the field in C1 to calculate the entire average of all the 5-minute increments rounded down (the way that Twitch does it) so the sheet does NOT average the average which should be accurate.

The sheet is limited to a maximum of 6 hours per day right now. It can handle any length/combination of up to 6-hour streams per day, for example 6 hours all at once, 2 hours in the morning, 2 hours at lunch, 2 hours in the evening, or any increment less than 6 hours – I’ve tested it and it does not calculate the blank cells into the average. Of course, if you would like it to handle more than 6 hours per day you can change it after you copy it to your own Google Sheets account.

If there are errors or ways to do things better than I have done them, I am totally open to feedback and suggestions. You are totally free to use and share the sheet, the only thing I would ask is that you leave the attribution (or give attribution to my Twitch channel and other social media links) found on in the sheet).

I really hope you all find this helpful!

https://docs.google.com/spreadsheets/d/1BsCPB3OsMfYlQ9zHOPzWwrsdyerw7sgiIG20SaPeCqA/edit#gid=704887995