ARRAY Function with Nested IF(OR) - Please Advise

I have a table of data consisting of OFFSET named ranges (columnar data) in a sequential order to execute an array function to sum results. One of the columns contains multiple variables that I would like to return SUM values for by executing the ARRAY function. Below is the order of columns/ranges:

Date City CostElementID HoursWorked

I am attempting to SUM the total hours worked based on the order provided in my array function below. Note the [CostElementID] is the range containing multiple variables I'd like to return a cumulative SUM value for. Here is the formula I've written out, however, it's not working...

{=(SUM(IF((Date=$#)*(City=$#)*((OR(CostElementID="####",CostElementID="####",CostElementID="####"))),HoursWorked))}

Can someone please tell me if this is even possible and what I'm clearly doing wrong?