Formula
Find the average score of all student ids without a zero homework score.
Cell L2
Use Function AVERAGEIF
Range F7:F29
Criteria: "0"
Average_range: "Homework"
Microsoft Office Specialist | 77-420 Exam Topics | 77-420 Questions answers | 77-420 Test Prep | Excel 2013 Exam Questions PDF | 77-420 Online Exam | 77-420 Practice Test | 77-420 PDF | 77-420 Test Questions | 77-420 Study Material | 77-420 Exam Preparation | 77-420 Valid Dumps | 77-420 Real Questions | Microsoft Office Specialist 77-420 Exam Questions