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!