“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Hello, how to get the average of numbers? I am trying to get Excel to calculate a commission on a "less than simple" pay structure. Essentially, I get paid a percentage of net sales. That percentage is determined based on 2 criteria. For example: If my "Products Per Deal" is 1.00 and my average income per deal is $1000.00, then I will be paid 13.00% commission. If my "Products Per Deal" is 1.3 and my average income per deal is $1200, then my commission will be calculated at 15.50%. I have a table set up, I just don't know how to get Excel to figure out what percentage it is.

Solved by C. D. in 27 mins

I have a row of 5 cells. Sometimes There might be information in 2, 3 or 4 cells.
I am trying to construct an average, regardless of how many are filled. The numerator is the Autosum.
The denominator is the number of cells with a value. How do I get the denominator. plz

Solved by C. D. in 20 mins

Please help to learn how to find average of a column in the table?

Solved by D. U. in 26 mins

I collect GPS data on 11 footballers each training session and import the data into excel, therefore after each session 11 new rows of data will be added (1 for each player). How would I create an average of this data for only the last 4 sessions, which would automatically update each time I import more data. Thanks

Solved by Z. D. in 12 mins

Hi, so I have the check in times and check out times for rooms in a hospital, and have to calculate the average room occupancy per hour in a given month.

Solved by F. L. in 28 mins

I want to create a spreadsheet that will calculate the return on an investment that pays out on a daily basis. The investment calculates the average payout for the last 30 days, so I want to be able to change the average daily payout to see how it will affect the returns moving forward.

Solved by T. H. in 30 mins

1. Please calculate “Roomed Census” (see below for definition) for every hour beginning on February 1, 2014 at 1:00 and ending February 28, 2014 at 23:00 (this is 671 values). Now average these values based on hour of day across the entire month. What is the busiest (highest census) and the least busy (lowest census) hour of day for the ER, and what is the average census at those two hours?
a. Roomed Census - This is the number of patients who are in rooms at a given point of time - census is a snapshot in time. Patients in rooms can be thought of as those who have been placed in a room but have not left as of that point in time.

Solved by T. C. in 15 mins

Need help on average value of a function over an interval. I am looking for a formula that corrects allocates units from Jul to Dec. So I have 6 months, average km per day is 50 and column G is the interval km per day. I want to get rid of the decimal. instead of having part as 0.5, 0.5, 0.5, 0.5 in 4 months I want to have 0, 1,0,1.

Solved by B. C. in 14 mins

Ho do you calculate average in excel using time (amount in a time period)

Solved by X. Y. in 13 mins

I have 2 separate files, one with clock in and out times for employees, and another with customer response times per customer. I want a way to average all of the response times per employee during the time that they are clocked in. The response time information is time stamped.

Solved by T. F. in 17 mins