I need to sum up the total wall volumes processed on a given day at a given time. I am using a SUMIFS statement to sum the wall volume when the date matches a specific one, and when the time of day is 3:00 PM
This is the formula I have:
=SUMIFS([Total Walls]@row:[Total Walls]@row, Date:Date, =[Every Date]@row, [Time of Day]@row:[Time of Day]@row, ="3:00 PM")
The range I want to sum from is the Total Walls column, I am checking the Date column (as there are multiple entries on any given day) to match all dates to the specific date I am looking for [Every Date]@row. The second criterion is to make sure the time of day is 3:00 PM when searching along the Time of Day column.
