The following formula only sums one line of a spreadsheet. It should match a specific value in one tab and add all lines with this value together. It does not.
=SUMIF('Operating Exp.'!D2:S150,VLOOKUP(SUMMARY!A5,'Operating Exp.'!D:S,16,FALSE),'Operating Exp.'!D2:S151)
Solved by D. Y. in 25 mins