I am using google sheets to automatically track how many times the garage doors are opened through IFFFT.
I have ‘Garage door’ and ‘Third stall’, the 2 different variables (doors) to track.
I am currently calculating the total cycles in column F, but I would like to track how often each one is opened/closed every day, on average.
I feel like I’m close with the :AVERAGEIF query, but I can’t quite get it right.