SUMIFS giving #INCORRECT ARGUMENT SET
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.
Answers
-
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?
-
@Paul Newcome Yes they are both set up as Date columns, not strings.
-
What happens if you take the Time of Day range/criteria set out?
-
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")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!