You can amend the first version to do that for a block of rows, e.g. this version will average all par 3 scores for rows 2 to 10 (excluding any blanks)
=AVERAGE(IF(B1:J1=3,IF(B2:J10<>"",B2:B10)))
confirmed with CTRL+SHIFT+ENTER
or do you want to average discrete rows?
Bookmarks