To create a simple example, a three column spreadsheet. Column A is Student Name, Column B is grade (1 through 100), column C is Assignment type (Test, Paper, Quiz, or Worksheet).
I want to use Averageifs to find the combined average of all tests and quizzes for a given student.
I have tried using an array formula
I have tried using OR() in an averageifs, but cannot get the syntax to work.Please Login or Register to view this content.
Any chance someone could offer some insight here?
Thanks for your help!
Bookmarks