Are you stuck on Excel or Google Sheets?

Check out some problems solved by our top Experts or click here to post your own problem for free!

I need to calculate average number of male and female directors for each company in the Excel sheet.
Solved by D. Y. in 60 mins
I need to highlight all cells in red which are 75% above average
Solved by A. W. in 20 mins
I have a spreadsheet that shows a qty range for each part number such as [ 1400 - 2000 ]; what is the formula for calculating this as an average - there are many part numbers so I need a formula I can copy and paste. thanks so much
Solved by S. E. in 19 mins
I'm trying to figure out how to calculate average reaction time for correct responses. I currently have one collum with either a 'C' or 'E' for correct or error and another collum with reaction time.
Solved by Z. Q. in 8 mins
How do I find the numbers whose average is equal to 321. Each of the 6 numbers has a parameter. (0,50),(51,100),(101,150),(151,200),(201,300),(301,500).
Solved by M. A. in 37 mins
Trying to get certain columns to average, instead of including everything.
Solved by D. E. in 15 mins
I have a table with 8 values in it. I am trying to split the table into 2 groups with the lowest average difference between them.
Solved by G. E. in 60 mins
This is the problem your team consists of 10 advisors . one advisor is able to complete on average 22 items per day(split:10 written, 12 emails) Time to complete averages 20 mins written, 12 mins email. You currently receive 144 written & 83 Email per day. You have a backlog of 3200 letters, 1000 emails. How long will it take you to clear the backlog and return to the daily SLA's Is there a way of showing me how to work this out in excel???
Solved by C. E. in 55 mins
Looking for a formula to see the average amount of times something is made throughout the course of the week (Monday-Friday) from date form and name of product
Solved by S. A. in 37 mins
I am trying to average cells that have zeros in them and I want to exclude the zeros in the average. I have tried the Averageif(B2:b13,"<>0") but it won't work? Any ideas?
Solved by E. U. in 40 mins
1 2 3 4