you need a sumproduct formula similar to: -

=sumproduct((A1:1200="season")*(B1:L1200="goal scorer))

"Purfleet" wrote:

Could someone please tell me the best way of doing this

I have a large spreadsheet (1200 rows and 25 columns wide) with all the
games my football team have played, arranged like

Game,Season,Date,Opponents,Competition,Division,Ty pe,Result,Score(us),Score(them) Venue,Notes,Manager,Goals
1,Goals 2,Goals 3,Goals 4,Goals 5,Goals 6,Goals 7,Goals 8,Goals 9,Goals
10,Goals 11.

In the goals coumns (Goals 1 thru to Goals 11) are the names of the people
who scored i.e Glenn Poole, Adam Parker etc etc.

I need to look up the season column and then count the goals columns (Goals
1 thru to Goals 11) so that the table looks somehting like

Players Glenn Poole Adam Parker
Season
2003-04 5 3
2004-05 2 1

Please HELP!!!!!