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

I want to automatically average for every 5 rows and for the averaged row to appear in a new sheet.

Solved by E. Q. in 21 mins

How to average sum per person in excel. I need assistant

Solved by M. A. in 16 mins

This is my current formula
=IF(D9>0,IF(J$6=TRUE,FRINGE!$F$37,(SUM(H9:K9)+SUM(N9:O9)+SUM(E9:G9)*8/2080+SUM(L9:M9)*12/(D9*2080))),0)
This formula takes the employee's hourly wage (D9) and either uses an average fringe rate (J$6=TRUE, FRINGE!$F$37) OR calculates the individual fringe rate for the employee 9SUM(H9:K9)+SUM(N9:O9)+SUM(E9:G9)*8/2080+SUM(L9:M9)*12/(DR*2080),0
to return the hourly wage INCLUDING fringe benefits
The fringe benefit rates are expressed as % in this workbook.
I need to expand upon this formula to take into account Temporary (T), PartTime (PT), and Seasonal(S) employees who do NOT receive fringe benefits.

Solved by G. L. in 27 mins

I need a contingency table that shows the average and standard deviation across different age groups given that each person's income is given in a different form either daily, monthly, hourly or others. ( The table contains around 45000 values)

Solved by X. D. in 14 mins

I want to average every 2 rows and have the averaged row appear in a new sheet.

Solved by B. S. in 23 mins

Hi !
I have a table on excel and I have to realise this instruction:
4.1.3. Display the averages of each column
• Click Total cell (D10), a drop-down list appears, proposing several types of calculations:
• in the drop-down list, choose Average
I do not have any drop down list when I click on the cell D10.
Could you please help me with that ? (on the enclosed excel file, I am referring to the disease sheet)
Maxime.

Solved by M. F. in 21 mins

I need a formula to find the average date of 3 given columns of dates assuming the years were 2019, that still works when one or more of the cells is blank.
Ex.
Given columns A(blank), B(5/31/2016), C(6/8/2015)
->the result I'm looking for would be 6/4/2019

Solved by G. H. in 25 mins

Hi, I need a formula to show the percentage difference between two numbers excel. The first two numbers are the "average extended price" and "low bidder price" and the second two numbers are the "engineer's estimate extended price" and the "low bidder extended price"

Solved by C. Q. in 16 mins

4. The worksheet will also show the average number of orders fulfilled for each column in the section above.
In cell B12, create a nested formula using the AVERAGE function and ROUND function in excel to first find the average number of boxed sets sold in January (the range B6:B9), and then round the answer to 0 digits.
Copy the formula from cell B12 to the range C12:N12

Solved by E. E. in 25 mins

I have a range of cells from E7:E13. Their values are represented as percentages. I need to obtain the average percentage from this group of cells. HOWEVER, cells may or may not have a value in them. I do not want blank cells figured into the average.

Solved by M. H. in 15 mins