# Why is this function not working?

Options

=SUMIFS([Hours Left]@row, [Assigned To]@row, "Person's Name", [Due Date]@row, >=DATE(2023, 8, 1), [Due Date]@row, <=DATE(2023, 8, 29))

I have values in the "SUMIFS" column, but it does not work. What is wrong. It is giving me the output of all my values being zero.

• ✭✭✭✭✭✭
Options

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?

##### Sincerely,

Jacob Stey

• Options

I would like to display the number of hours of work left per task if the end date falls between those dates listed. I want it to be able to display this for each task.

• ✭✭✭✭✭✭
edited 08/14/23
Options

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))`

##### Sincerely,

Jacob Stey

• ✭✭✭✭✭✭
Options

Hi,

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!