SUMIFS Using VLOOKUP Range

[MPierce486]

I am trying to SUMIFS using multiple criteria, but one of the criteria is dependent on another table. See below.

I am trying to sum up all amounts with a "111" account number AND where the "Code" is equal to "Equity". The first part is easy by using =SUMIF(A3:A8,111,C3:C8). However, I'm unable to a VLOOKUP for the next part since I cannot select a range as the lookup_value. Using =SUMIF(VLOOKUP(B3:B8,E3:F7,2),Equity,C3:C8) does not work.

I have tried using SUMPRODUCT or SUMIF along with INDEX & MATCH, but no success yet. Any help is appreciated. Thank you!

 

[MPierce486]

You can do a helper column. Put the vlookup in column D and use that in the sumproduct. I guess you are running an old excel.

I'll just use this solution for the time being and will upgrade to your formulas if/when I upgrade my version of excel. Thanks!