C caitlyn New Member Jun 9, 2017 #1 I need help with a formula to first lookup values in rows with a specific title, then average that value across only one row. On the attached sheet, I need each the average of each students R1-R8 score. Attachments Year 8 Reading Milestones.xlsx 16.1 KB · Views: 5
I need help with a formula to first lookup values in rows with a specific title, then average that value across only one row. On the attached sheet, I need each the average of each students R1-R8 score.
B bosco_yip Excel Ninja Jun 9, 2017 #2 In C3, formula copy across and down : =IFERROR(AVERAGEIF($K$3:$V$3,C$3,$K4:$V4),"") Regards Bosco
