Why is this function not working?

Hi @David2425,

What is it that you would like for the formula to do?

Currently it looks like it is adding the amount of hours left if the "Person's Name" matches the criteria.

What are you expecting as an output?

If you want to SUM the amount of hours per individual you can use this formula:

=SUMIFS([Hours Left]:[Hours Left], [Assigned To]:[Assigned To], "NAME HERE", [Due Date]:[Due Date], >=DATE(2023, 8, 1), [Due Date]:[Due Date], <=DATE(2023, 8, 29))

If you want to SUM the hours left per task, that formula will be a little different depending on the column name for tasks.

=SUMIFS([Hours Left]:[Hours Left], [Task Column]:[Task Column], "Task Name", [Due Date]:[Due Date], >=DATE(2023, 8, 1), [Due Date]:[Due Date], <=DATE(2023, 8, 29))