Incorrect Sumproduct Array

[ltmaiyk]

Hi --

I am trying to sum up the total number of hours consumed on a particular activity within a specified period.

=SUMPRODUCT(($C38:$C176>=$B7)*($C38:$C176<=$C7)*($B38:$B176=$D5))

Unfortunately, the formula above gives me the total number of activity and NOT the total number of hours within a specified period.

I attached the file I'm working on as reference.

Your help is very much appreciated.

Thanks in advance.

Maiyk

[DonkeyOte]

To go from a multi conditional "countif" test to a multi conditional "sumif" add the summation range...

=SUMPRODUCT(($C38:$C176>=$B7)*($C38:$C176<=$C7)*($B38:$B176=D$5)*$F$38:$F$176)

to show output in time format, apply a custom format to the cell of: [hh]:mm

[ltmaiyk]

Thank you so much.

I will remember that! Will change the status to SOLVED shortly..