SUMIF or SUMPRODUCT multiple conditions formula

Hi all,

I use the following formula to sum values if they fall between 05:00 to 06:00 hrs.
Where column 'B' is time and Column C arte values.
It works great.

Please Login or Register  to view this content.

I want to add multiple conditions to sum.
I have attached the test file.

If anyone can kindly help please.

Kind regards

Formula:

Please Login or Register  to view this content.

Hi Need for excel
Great work indeed.
All works well.
Just one question.... If any of the column that I am referring to is a date then ,
To refer to particular month the formula will be ?? example is for Month of May = 5

Please Login or Register  to view this content.

Is this correct?
I am closing the thread as solved.
I have clicked *** to thank you.

Also Czeslaw , Thank you for your help. It also works well.
I have clicked *** to thank you.
Thanks again all
Kind regards

Hi,

You have dates in column A, so you need to modify your formula as following:

=SUMPRODUCT(--(HOUR(B2:B11)=5),--(MONTH(A2:A11)=5),--(D2:D11=1),E2:E11)

Hi Cbatrody,
Great help.
It works well
Thanks