Summing up lookupvalue or sumif

I have two tables and I am trying to get the sum of the expenses when certain columns match. 

Here is a lookupvalue formula i would uses and if there is a way to sum up the values that would be great. 

Summed Expense = LOOKUPVALUE(Expense[Expense],Expense[Accountno],'Expense Variance Column'[Acct_no],Expense[Department],'Expense Variance Column'[Dept_no],Expense[Location],'Expense Variance Column'[Location_no],Expense[Projectid],'Expense Variance Column'[Projectid])

I have used a merge function and then aggergate the sum of expense. That has worked before for different things, but not this one. When i have done the merge and aggregate it, the amount of time it takes to refresh increases substantially. . If there i like a sumif instead of a lookup then i can use that instead.