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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!