How to use SUMIFS
Hi Community!
I need to track the hours I spend on different tasks in a week.
Then, I need to sum the column "hours" if "date" is inside a specific period of time and if "done" is checked.
I tried the following formula, what should I correct? Thank you so much!
=SUMIFS(hours1:hours4, Date1:Date4, {Date Range}>= DATE(2023, 1, 01) <= DATE(2023, 1, 07), DONE1:DONE4, 1)
Best Answer
-
=SUMIFS(hours1:hours4, Date1:Date4, >= DATE(2023, 1, 01), Date1:Date4, <= DATE(2023, 1, 07), DONE1:DONE4, 1)
If you add more rows it won't work because you're specifying partial amounts of the column to check.
Answers
-
=SUMIFS(hours1:hours4, Date1:Date4, >= DATE(2023, 1, 01), Date1:Date4, <= DATE(2023, 1, 07), DONE1:DONE4, 1)
If you add more rows it won't work because you're specifying partial amounts of the column to check.
-
Thank you so much! It worked
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!