Sum product between specific dates

[mwedemeier11]

Hi, currently what I have is a table where we list the date, hours either lost or gained during production, and then a reason why (ie. system issues). I have set up the formula =SUMPRODUCT((D4:D800="System Issues")*(C4:C800)) to tally up the overall total of the Hours Lost/Gained if the description is "System Issues"


What I would like to add to this is for it to only count through the list if it falls in the specified range of dates that I have chosen. I have two cells (P1 which displays the start date "04/24/2013" and P2 which displays the end date "05/01/2013")

can someone help me out?

[Jonmo1]

Assuming your dates are in column E

=SUMPRODUCT((D4:D800="System Issues")*(C4:C800)*(E4:E800>=P1)*(E4:E800<=P2))

[mwedemeier11]

That is perfect, thank you so much!

[Jonmo1]

Great, glad to help