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

[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

 

[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

 

[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