“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

Hi i need a formula for finding the percentage of students, whose grade is 4 and above in english and math

Solved by K. H. in 13 mins

My formula doesn't work (showing #VALUE!):
Here is the formula that needs to be applied:
= = 150 - (150*EXP(-A3*500)) where A3 is 0.002

Solved by C. D. in 28 mins