Look up and count

P

Purfleet

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

Please HELP!!!!!
 
A

Anthony Slater

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

count accross columns 4
group by dates 1
calculating from combined worksheets 1
Look Up and Count 4
Row count value evaluated against different thresholds. 3
Look up 1 value and return a set of values 0
League standings based off final scores 5
Adding up multiple worksheets by name and totals 5

Top