Count and Sum from multi lists

[rjn008]

Afternoon,

Can anyone help on the below;

We run a football syndicate and record winning selections and losses throughout the season by person. But it would be good to know the number of times a team has been selected and whether the result was a W, L or D.

The format is as below, I have 2 sheets for diff reasons, and these aren't linked as I dont know any good way or transposing the data;

Sheet 1

Sheet 2

Thanks
Richard

 

[Rijnsent]

Hi Richard,
for people that don't have your spreadsheet (nor your background knowledge) it's hard to give you a good answer. Some ideas though: to count the nr of times a team is selected you can probably use COUNTIF / COUNTIFS, otherwise maybe a SUMPRODUCT. Exceljet has quite good examples of most formulas: COUNTIF Function
Transposing data is also something you can do with formulas, but than I really would need to see the workbook itself.
Cheers,
Koen

 

[rjn008]

Hi Richard,
for people that don't have your spreadsheet (nor your background knowledge) it's hard to give you a good answer. Some ideas though: to count the nr of times a team is selected you can probably use COUNTIF / COUNTIFS, otherwise maybe a SUMPRODUCT. Exceljet has quite good examples of most formulas: COUNTIF Function
Transposing data is also something you can do with formulas, but than I really would need to see the workbook itself.
Cheers,
Koen

I have used a COUNTIFS on each individuals selections and then just summed them up which gives me the answers I need, which I feel probably is the best way as if things change I am unsure how any coding could cope with that.

Thank you for your response.