How to use SUMIFS

Micaela Passetti

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)

Mike TV

@Micaela Passetti

=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.

Mike TV

@Micaela Passetti

=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.

Micaela Passetti

Thank you so much! It worked