Golf Scorecard issue

Hi guys,

I am making a very detailed scorecard for golf. The thing is that I can't seem to find out how to have the average number of strokes for a given par. So some kind of formula that will look at the holes and see the par 3's (for example) and be able to average the scores for all the holes with that par. I am pretty beginner and was thinking about a COUNTIF formula or something?

I've uploaded a little sample of my scorecard for you to see what I'm trying to do. I hope it helps.

Thanks!

You can either use an "array formula" like this

=AVERAGE(IF(B1:J1=3,B2:J2))

confirmed with CTRL+SHIFT+ENTER

or this "regular" formula will give the same result

=SUMIF(B1:J1,3,B2:J2)/COUNTIF(B1:J1,3)

Originally Posted by daddylonglegs

You can either use an "array formula" like this

=AVERAGE(IF(B1:J1=3,B2:J2))

confirmed with CTRL+SHIFT+ENTER

or this "regular" formula will give the same result

=SUMIF(B1:J1,3,B2:J2)/COUNTIF(B1:J1,3)

Thanks for the reply.

I see that works and everything, but would I be able to highlight a lot of rows all at once (future golf scores) so that my average for "Par 3's" (for example) will be updated automatically?

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?