ARRAY Function with Nested IF(OR) - Please Advise

[huntethic]

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?

[Tony Valko]

Use cells to hold the CostElementID variables. Assume they're in A1:A3.

Then your formula becomes:

=SUM(IF((Date=$#)*(City=$#)*ISNUMBER(MACTCH(CostElementID,A1:A3,0)),HoursWorked))

Still array entered.