 # Get instant live Excel expert help with AVERAGE Function “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

20. For each product… what is the average profit per 1 item sold and what is the average profit margin per 1 item sold? 21. Which products have the highest profit margin (top 50)? 22. Which products have the highest cost (top 50)?
Solved by B. S. in 19 mins
I am trying to get a column of percentage (GRADES) using the COUNTIF function to excel count cells with value or text, then SUM only those cells. Here's the formula I have so far, but it is not working; =COUNTIFS(C8:C41,"<>"&"",F8:F41,"AVERAGE")
Solved by M. E. in 30 mins
I need to find the average weekly and per post "organic" reach and engagement. Amount of posts per week vary.
Solved by D. U. in 11 mins
I need to do a weekly average for reach and engagement
Solved by C. H. in 26 mins
Modify the two Values fields to determine the average Issue Price and average Est. Value by type. Change the custom name to Average Issue Price and Average Est. Value, respectively.
Solved by G. F. in 19 mins
I need to know the formula as to average the individual GREEN, RED, and BLUE cell data together in the TOTAL GREEN, RED, and BLUE cell at the bottom that have data in the cells. So, if there is no data in the individual cells the AVERAGE formula ignores these cells, and only averages the ones with numbers. There is not a specific 'range' for this, but the individual cells for each color that needs to be AVERAGED.
Solved by O. B. in 23 mins
I contacted you yesterday about average function excel 2010, and for real numbers it works fine, but I tried to get the expert to explain to me how to use the =AVERAGE function when the cells have formulas in them that generate '0' value, so the AVERAGE function would ignore these cells in the averaging method, but got no answer. So, I need to know how use the =AVERAGE function so that when there are formulas in the selected cells to average, that EXCEL would ignore those cells like they have real numbers in them, which seems to work fine. Please advise...
Solved by C. J. in 14 mins
Trying to calculate a work date based on 2 known inputs - start date and number of working days allowed on the project. The dilemma comes when looking at the data chart that gives the average number of work days per month. It varies from 5 days to 23 days depending on the month. Need to create a formula(s) that takes the inputted date and calculates an accurate completion date based on the variable work days.
Solved by S. J. in 30 mins