Hi, I am new to the forum so apologies if I do anything annoying.
I have built a spread sheet that tests the ventilation rates for rooms in a building. From the software I use I get an export of the flow rate for every hour of the day over the summer across multiple rooms.
I need to know if the daily average goes below 5 l/s/person and for how many days. Hence the number of people in each room is an input.
The spreadsheet I have built works fine. But it calculates the daily average for all 24 hours of the day and weekends etc.
Ideally I would like to improve it to only consider taking a contribution to the daily average at times when the filter is equal to 1. Hence certain times and days can be filtered out.
Does anyone know if this is possible? Ideally I would like to avoid Macros. But if they are required that is fine.
As the sheet is for up to 100 rooms I really need to minimise extra columns.
I just need a tweak to the formula in column D to account for the filter.
Any help would be greatly appreciated.
Ross
Bookmarks