“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

need to work data from Hyperion Budget Dump Exp to Forecast.this is an excel descriptive statistical

Solved by M. J. in 14 mins

need to match numbers on one tab(non personnel exp column AB) to another(GL 071 trans detail column S) and return value and description to Non personnel exp tab (columns AC and AD)

Solved by I. Q. in 29 mins

need to match data from Hyperion Budt Dump Exp to Forec with specific conditions

Solved by M. H. in 18 mins

=SUM(SUMIFS(AC!$N$5:$N$1918,AC!$D$5:$D$1918,"1712",AC!$F$5:$F$1918,"M",AC!$H$5:$H$1918,{"EXP","MED","MISC"}))+SUM(SUMIFS(AC!$N$5:$N$1918,AC!$D$5:$D$1918,"1712",AC!$F$5:$F$1918,"MV",AC!$H$5:$H$1918,{"EXP","MED","MISC"}))*0.5+SUM(SUMIFS(AC!$N$5:$N$1918,AC!$D$5:$D$1918,"1712",AC!$F$5:$F$1918,"MR1",AC!$H$5:$H$1918,{"EXP","MED","MISC"}))+785

Solved by B. H. in 28 mins