SUMIFS giving #INCORRECT ARGUMENT SET

atewari1

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.

Paul Newcome

Are both the Date column and [Every Date] column set as date type columns and populated with actual dates (as opposed to text strings that look like dates?

atewari1

@Paul Newcome Yes they are both set up as Date columns, not strings.

Paul Newcome

What happens if you take the Time of Day range/criteria set out?

atewari1

I fixed the issue. I removed the @row from the ranges. The formula now is:

=SUMIFS([Total Walls]:[Total Walls], Date:Date, =[Every Date]@row, [Time of Day]:[Time of Day], ="3:00 PM")