 # Get instant free expert help with Excel and Google Sheets “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

i need a chart to keep my invoices numbers, names amount date and description
Solved by Z. Y. in 26 mins
I have a column of numbers that change or can be the same and i need to count how many times each number is in that column and then on a new spreadsheet write that number and how many times it appeared
Solved by A. Q. in 15 mins
i keep getting the #N/A for this vlookup =VLOOKUP(I3,A3:D6,4,FALSE) what's wrong with it?
Solved by E. A. in 12 mins
really need help trying to pick data from 7-am-7am day to day. I am close but need additional help to finish it off...... thanks
Solved by V. L. in 18 mins
Hello I am trying to use Auto sum . After I total up some cells, When I go to change one cell it does not total up automatically. I have to reuse auto sum every time I make a change. Do you know how I can fix that?
Solved by T. W. in 15 mins
I need to use the SUMIF function dynamically in VBA. For the range, I have tried to build the range: "\$C\$2:\$C\$" & lastRow, but it does not work. I then created the variable: MyRange = \$C\$2:\$C\$ & lastRow and then I place MyRange in the SUMIF formula. Nothing works! An example of code: lRow = Cells(Rows.Count, 3).End(xlUp).Row myAddress = "\$C\$2:\$C\$" & lRow MsgBox TypeName(myAddress) Range("I:I").ClearContents Range("I1").Value = Month(dtDate1) Range("I2").Select ActiveCell.Formula = "=sumif(myaddress,h2,\$e\$2)"
Solved by T. D. in 25 mins
I am trying to do two drop down boxes with one dependent on the first. I am using =Index(Options, Match(C5, Drugs, 0)). I am using this in Libre and it works fine but in Excel it gives me a #REF error every time.
Solved by V. E. in 30 mins
I need to know if a formula can be written to pull information from one excel into another based off multiple criteris. vlookup index match might work, I cannot get it to work and can upload the files
Solved by B. C. in 26 mins
Trying to create a button that is on a sheet in a workbook that updates the value in my personal workbook that is always open.I need to do this on 10 different workbooks. so I kinda need an explanation. I also don't have an example.but I'm making a mini database that updates with a button on multiple workbooks.
Solved by A. U. in 24 mins
Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. Good B7 = .0325 B8 = 5 E6 = 275000 Most Likely B7 = .057 B8 = 5 E6 = 312227.32 Bad B7 = .0700 B8 = 3 E6 = 350000 Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately.
Solved by A. A. in 17 mins