Get instant live expert help on exp function excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
need to work data from Hyperion Budget Dump Exp to Forecast.this is an excel descriptive statistical
Solved by M. J. in 14 mins
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 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 V. B. in 26 mins