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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!