Creating a formula to calculate estimated hours in next 14 days
Has anyone created a SUMIFS equation that could calculate the estimated hours in the next say 14 days?
Below is what I thought would work.... but it just keeps saying "0"
I want this equation to calculate the estimated hours per task/child row (HC - Project header is not checked) within the next 14 days.
=SUMIFS([Est Hrs]:[Est Hrs], [HC - Project Header]:[HC - Project Header], "0", Finish:Finish, >90
NOTE: HC - Project Header = a check box to help differentiate project header/parent information verse task/child information
Thanks for your help in advance!
Help Article Resources
Check out the Formula Handbook template!