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
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!