Look up and count



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,Type,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
2003-04 5 3
2004-05 2 1

Please HELP!!!!!


you need a sumproduct formula similar to: -

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

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

Similar Threads