Forum Discussion
Averaging highest grades
Hi, I teach a class, and have an excel spreadsheet. Format: Test 1 Retest 1 Test 2 Retest 2 Test 3 I'd like it to find the Highest grade of the first two, the Highest grade of the second...
JMB17: Hi, got an email with your suggestion, but could not see the attachment, or the post, nor reply to your email.
I Googled awhile ago, and it also recommended the AVERAGEIFS and values >0, and I VERY carefully checked the syntax, and the Excel spreadsheet would Not allow me to enter that formula, and kept insisting it was in error, and not a correct formula! Drove me crazy, and led me to this forum!
I Googled awhile ago, and it also recommended the AVERAGEIFS and values >0, and I VERY carefully checked the syntax, and the Excel spreadsheet would Not allow me to enter that formula, and kept insisting it was in error, and not a correct formula! Drove me crazy, and led me to this forum!