Creating a formula to calculate estimated hours in next 14 days

Jenna Kiehl

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!

Jenna Kiehl

Figured out an answer to my question! I included my steps and a reference image to illustrate my solution.

Steps to success:

1. I wanted to track these Estimated Hours Total in a new sheet to help summarize the data, so I created a new sheet that included the Date Ranges (primary column), Dates, and Est Hrs Total
2. I included todays date and the date ranges I was looking for
3. Then I added a dates column to reflect todays date, then 14, 30, 60, and 90 days out.
4. Then in the next column (Est Hour Total) I added the equation referencing the sheet I wanted to summarize.

Image of my real sheet:

Equation (if in same sheet):

=SUMIFS([Est Hrs]:[Est Hrs], [HC - Project Header]:[HC - Project Header], "0", Finish:Finish, <Dates@row)

NOTE: The equation and reference image below is showing how the equation would work in the same sheet.

Jenna Kiehl

Figured out an answer to my question! I included my steps and a reference image to illustrate my solution.

Steps to success:

1. I wanted to track these Estimated Hours Total in a new sheet to help summarize the data, so I created a new sheet that included the Date Ranges (primary column), Dates, and Est Hrs Total
2. I included todays date and the date ranges I was looking for
3. Then I added a dates column to reflect todays date, then 14, 30, 60, and 90 days out.
4. Then in the next column (Est Hour Total) I added the equation referencing the sheet I wanted to summarize.

Image of my real sheet:

Equation (if in same sheet):

=SUMIFS([Est Hrs]:[Est Hrs], [HC - Project Header]:[HC - Project Header], "0", Finish:Finish, <Dates@row)

NOTE: The equation and reference image below is showing how the equation would work in the same sheet.

Genevieve P.

Hi @Jenna Kiehl

Thank you for taking the time to post your solution and steps to success!

Cheers,

Genevieve