excel golf scores, how do I add the scores for all par 3's etc

G

Golf Analyst

I would like to add and average scores for all par 3's then par 4's & par 5's
to analyse golf scores on different coures leavig the base data in its
original hole be hole format
 
B

Bernard Liengme

How is the data set out?
How do we identify a par 3?
We want to help but need more info
best wishes
 
F

Fred Smith

Assuming you have entered the par for each hole in your table, you can use the
Sumif function. The formula would be something like:

=sumif(a1:a18,3,c1:c18)

To average, do a Sumif/Countif
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top