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
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!