Why is this function not working?
=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.
Help Article Resources
Check out the Formula Handbook template!