Sumif with multiple conditions

I need to sum cells in an array when multiple conditions are met within other columns and across sheets. I need help knowing what formula would work to accomplish the following:

Sum cells in the array found at Data1DBQ3:FSC11000 when Data1 n3:n11000 equals the number found in sheet "report1" cell i6 and

when Data1 DBQ2:FSC2 contains text "recent" and

when Data1 DBQ2:FSC2 contains text that matches text found in sheet "report1" cell L4.

HELP!

Haseeb,
Thank you for your help. I can see in your suggested formula where you have included two of the searches/conditions I need, but I don't see the third. Also, report1!I6 is a value and Report1!L4 is text.

I've attached a dummy sheet

and what it suppose to produce if a formula works

Criterias
1. Contract
2. departure will always be from 1 location, ie 24
3. destination, will be different destination points

What i'm trying to calculate is how much volume is traveling from a 1 specific departure point but to multiple destination points.

Thanks for the support and the dummy file. I cannot attach the file or any portion of the file as the information is confidential and proprietary. I have created a file that will simulate what I am working with and allow us to trouble shoot the sumif or sumifs formulas.

See the attached file.

Again, I need to sum cells in an array when multiple conditions are met within other columns and across sheets. I need help knowing what formula would work to accomplish the following:

Sum cells in the array found at Data1DBQ3:FSC11000 when Data1 n3:n11000 equals the number found in sheet "report1" cell i6 and

when Data1 DBQ2:FSC2 contains text "recent" and

when Data1 DBQ2:FSC2 contains text that matches text found in sheet "report1" cell L4.

Thanks for any assistance.

Try

=SUMIFS(Data1!$DBQ$3:$DCD$3,Data1!$DBQ$3:$DCD$3,Report1!$I$6,Data1!$DBQ$2:$DCD$2,"Recent*",Data1!$DBQ$2:$DCD$2,"*"&Report1!$L$4)

It results in 2

Thank you. It does result in 2. However, when some of the data numbers are changed, the formula stops working correctly. I am not sure why. Thanks for the assistance. The sum product formula does work.

Thank you. The sum product formula does work. It does not take long to calculate. I will mark this solved. I really appreciate the help.