I need to use a logical "or" in AVERAGEIF but this does not seem to work
I teach band and I am running a little Harry Potter style "House Cup" competition. I have a spreadsheet that contains my rosters including the instrument each student plays. Their "Houses" Are broken up by instruments, flutes, clarinets, etc, but for some smaller sections multiple instruments are grouped together. I need to compute the Average grade percentage for each house.