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 column L, calculate the overall average grade for each student’s chapter assignments and exam. The overall average grade is the average of the contents in columns D through J. In Row 14 for each chapter and exam, create an AVERAGEIF function to calculate the average grade for those students who actually received a grade other than 0. Format both Row 14 and Column L to show one decimal. -In column M, calculate the final grade using a nested IF statement using the guidelines below: ------------ -Use conditional formatting in the final grade cell using light red fill with dark red text for any student earning an F. RULES ARE DOWNLOADED
Solved by M. U. in 24 mins
I just need to edit this formula, {=IFERROR(AVERAGEIFS(B6:D6,F6:H6,"FALSE"),AVERAGEIF(B6:D6,"<>0"))}, to return "-" or "0" if there is nothing in column D. I can share the entire worksheet if need be.
Solved by V. A. in 30 mins
I need an averageif formula for a set of individual cells rather than a series.
Solved by K. J. in 28 mins
I need to use an AVERAGEIF function that allows me to average a range of numbers that have individually attached 'Yes, No' drop down boxes underneath them using data validation. Within the range, I only want the average for the values that have yes underneath.
Solved by X. J. in 27 mins
My weighted average formula is not getting applied on a google response sheet. returning a Div/0 error
Solved by S. F. in 29 mins
I am trying to create an "Average" field to calculate the average of multiple columns in a pivot table (each column separately that is) knowing that the rows under each column will change according to slicer selection. I was able to create the formula to calculate that but i just noticed that once the reference word in my formula (which is "grand total") falls after row 99 then the formula gives no results !! here is the formula =IFERROR(AVERAGEIF(INDIRECT(B10&"15:"&B10&RIGHT(CELL("address",INDEX($A$13:$W$101,MATCH("Grand Total",$A$13:$A$101,0),1)),2)-1),"<>0"),"") any suggestion?
Solved by A. H. in 24 mins
In cell B12, add an AVERAGEIF function that will find the average call length for the Dept named range and the criteria specified in cell A12. In cell C12, add a COUNTIF function that will count the number of calls for the Dept named range and the criteria specified in cell A12. In cell D12, add a formula that sums two COUNTIFS formulas. The first COUNTIFS will count the number of calls associated with the Dept named range and criteria specified in cell A12 that received a grade F, and the second COUNTIFS will do the same for grade D.
Solved by X. Q. in 19 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 11 mins
i need to add the countif and averageif function in excel to the project im working on.
Solved by S. C. in 22 mins
In cell H1, use the AVERAGEIF function to calculate the average resident cost of attendance (Res_COA) for colleges located in the State of Kansas. Hint: Be sure to use range names when creating the formula.
Solved by V. S. in 11 mins