Get instant live Excel expert help to learn how to find the average with if condition

“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

In All Closing worksheet, use AVERAGEIF function to calculate the monthly average stock price for five firms and NASDAQ, and show your results. After you input all possible month values, use mixed reference so that you will need to type formula with AVERAGEIF only once to calculate the monthly average price for all firms. Your results would look like following. (Notes: (1) the order of the month could be either ascending or descending; (2) You could show your results beginning from any columns or rows, as long as in All Closing worksheet.)
Solved by S. J. in 14 mins
Need help with average if() excel. Only Expert required.
Solved by O. J. in 15 mins
17. On the Summary worksheet, create formulas to complete the summary table in C5:G8. You must use conditional aggregate functions (COUNTIF, COUNTIFS, SUMIF, AVERAGEIF).
Solved by T. Q. in 22 mins
I need help with weighted average calculator
Solved by I. J. in 30 mins
what is definition of average? My homework is to calculate average among months of total apples.
Solved by V. L. in 29 mins
I want to learn averageif() in excel
Solved by V. W. in 28 mins
I need help with my averageif() formula
Solved by G. H. in 26 mins