Count If off of Pivot Table Results

[underbird]

Can you do i count if off of a pivot table result, if so how? example of data below. I would want a count of each golfers name

[TABLE="width: 746"]
<colgroup><col></colgroup><tbody>[TR]
[TD]G Jason Day G Adam Scott G Zach Johnson G Kevin Chappell G Francesco Molinari G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Rickie Fowler G Tiger Woods G Kiradech Aphibarnrat G Emiliano Grillo G Kevin Kisner G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Rickie Fowler G Tiger Woods G Louis Oosthuizen G Francesco Molinari G Kevin Na G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Rickie Fowler G Tiger Woods G Zach Johnson G Francesco Molinari G Patton Kizzire G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Rory McIlroy G Tiger Woods G Zach Johnson G Keegan Bradley G Chesson Hadley G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Adam Scott G Bubba Watson G Marc Leishman G Kevin Kisner G Chesson Hadley[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Adam Scott G Marc Leishman G Luke List G Zach Johnson G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Alexander Noren G Bubba Watson G Cameron Smith G Kevin Chappell G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Alexander Noren G Louis Oosthuizen G Kiradech Aphibarnrat G Kevin Chappell G Francesco Molinari[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Alexander Noren G Marc Leishman G Cameron Smith G Kevin Chappell G Francesco Molinari[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Alexander Noren G Marc Leishman G Zach Johnson G Emiliano Grillo G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Henrik Stenson G Brian Harman G Kiradech Aphibarnrat G Francesco Molinari G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Henrik Stenson G Bubba Watson G Kiradech Aphibarnrat G Francesco Molinari G Kevin Kisner[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Hideki Matsuyama G Marc Leishman G Zach Johnson G Kevin Kisner G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Tommy Fleetwood G Brian Harman G Francesco Molinari G Keegan Bradley G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Tommy Fleetwood G Marc Leishman G Emiliano Grillo G Kevin Chappell G Kevin Kisner[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Tommy Fleetwood G Patrick Reed G Kevin Chappell G Kevin Na G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Tyrrell Hatton G Adam Scott G Cameron Smith G Francesco Molinari G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Tyrrell Hatton G Brian Harman G Luke List G Kevin Chappell G Charley Hoffman[/TD]
[/TR]
[TR]
[TD]G Tiger Woods G Tyrrell Hatton G Marc Leishman G Kiradech Aphibarnrat G Emiliano Grillo G Charley Hoffman[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

You can but why not just run a counting pivot off the source data?