SUMIFS with multiple criteria in multiple columns

Hi -
I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I try I either get an error. Here is the formula I have so far (which is wrong - somewhere!)
=SUMIFS({Status}, "Project Completed", {Hours Saved}, {Date Completed}, >"01/01/ 2020", {Hours Saved})
Any assistance would be greatly appreciated.
Thank you,
Donna
Best Answer
-
It should be written as is. Can you copy/paste the formula directly from your sheet? You should not be receiving the #UNPARSEABLE error.
Answers
-
It is just a syntax issue. Try something like this...
=SUMIFS({Hours Saved}, {Status}, "Project Completed", {Date Completed}, @cell > DATE(2020, 01, 01))
-
Thank you for your help! This is driving me nuts! Is this part @cell > DATE(2020, 01, 01) to be written exactly as is, or does @cell refer to a specific field? Written as is I'm still getting an #UNPARSEABLE error.
-
It should be written as is. Can you copy/paste the formula directly from your sheet? You should not be receiving the #UNPARSEABLE error.
-
Your solution fixed it!! I had one to many parentheses at the end. Thank you so much!!
-
Happy to help! ποΈ
Those parenthesis can definitely be a pain sometimes.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!