# Get instant live 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 to create dashboard containing 4 charts(pie or histogram or any) and pivot table data
Solved by D. H. in 23 mins
Business Spread sheet. Need Help Create a pie chart to show the initial cost totals by department. You may create a set of summary data to the right of the current data to use for the creation of your chart.
Solved by T. U. in 15 mins
I have a list of Entities that each need a number of the same item. Some need as much as 72 of that item, some only need 1. I can only deliver 72 of that item per day, so I need to find a way to sort this list into asymmetrical groups where the total number of items needed per group is as close to 72 as possible without going over.
Solved by G. L. in 22 mins
In column I, enter a formula to calculate the insurance charge if the renter has elected insurance coverage (Yes in column E). Use the furniture’s group code and the Monthly Insurance column in the RentalCharges table to look up the insurance charge. Remember to multiply the monthly insurance charge by the rental period. If the renter has not elected insurance, the cost is \$0.
Solved by K. H. in 13 mins
Need help with several vlookup and pivot table questions.
Solved by I. S. in 16 mins
Hi, i have a spreadsheet which has 3 columns a = date b = time of day c = numerical result from a machine monitoring air pollution d = word describing where the person is at that time point i am trying to do two things 1. work out how long each person spends on each activity/place 2. work out total sum of the pollution monitoring for each activity i have tried sumif but it doesn't seem to work?
Solved by D. Y. in 11 mins
Write a formula for me that goes something like 'if cellA is in this range (between cellX and cellX*2), then 1. if cellA is in this range (between cellX*2 and cellX*3), then 2. Its a formula to increase '# of employees needed' based on sales volume (cellA) and hours worked capacity per 1 employee (cellX).
Solved by X. W. in 29 mins
While trying to substract multiple cells ''=H13-H2:H12'' (=*a cell*-*bunch of cells*) doesnt work while ''=G13-G2-G3-G4-G5-G6-G7-G8--G9-G10-G11-G12'' works. Tried it the same way in google sheets and it worked.
Solved by I. E. in 24 mins
Hi, I'm making a shedule calculating number of days with function (row 4) with number of hours/function (row 2). =(G4*G2)+(H4*H2)+(I4*I2)+.... Colum marked PROBLEM How can i get excel to do the same calculation for 2 rows for all functions G to AK. i.e =(G4*G2)+(H4*H2)+(I4*I2) + ... until (AK4*AK2)
Solved by X. C. in 21 mins
I currently have a large worksheet with over 7,000 cells. I have listed regions under a column i named "Location." In that column I want to change the region from lets say "Eastern North Central" to "US-Midwest," "Mountain" to "US-West" and so on. Is there anyway I could use a function to enter under my location column so all regions change to my desired classifications so i don't have to manually change over 7,000 cells? Perhaps some convoluted IF function?
Solved by Z. J. in 11 mins