Counting into other columns.

[mwindau]

I am working on a golf spreadsheet. How do I count the eagles, birdies, pars, bogeys, dbl bogeys, other score in separate columns from the Par and Score columns below.

A	B	C	D	E	F

<tbody>
</tbody>

Par	Score	Eagles	Birdies	Pars	Bogeys	dbl bogeys	Others
4	4
5	6
4	5
3	4
5	6
4	5
4	3
4	7
3	4

<tbody>
</tbody>

 

[Joe4]

Assuming the data above is in cells A2:B10, place these formulas in cells D2:H2
Birdies: =SUMPRODUCT(--(A2:A10-B2:B10=1))
Pars: =SUMPRODUCT(--(A2:A10=B2:B10))
Bogeys: =SUMPRODUCT(--(A2:A10-B2:B10=-1))
Dbl Bogeys: =SUMPRODUCT(--(A2:A10-B2:B10=-2))
Others: =COUNT(A2:A10)-SUM(D2:G2)

 

[mwindau]

Thanks that's what I was looking for.

 

[Joe4]

You are welcome.

I forgot Eagles, but that would just be the same formula as Birdies, changing the 1 to a 2, i.e.
=SUMPRODUCT(--(A2:A10-B2:B10=2))