Extracting Specific data from complex table

[Andrias14]

Hi Excel Forum guys

Im having some trouble extracting specific data from my table, i have to extract how many medals a team has won with out the medal count i was wondering what kind of formula i would use??

( i have whether they have won gold, silver, bronze and thats it)Winter Olympics.xlsx

[alansidman]

Try =Counta(A2:A37)

[Andrias14]

I need it per person though, so that guy got x amount and that guy got x amount i've already got the total

[XOR LX]

Hi,

Sorry if I'm missing something but I can't see where the table is set up to contain these results?

Regards

[Andrias14]

on the second sheet, there is an empty column saying no.Medals and thats where i want to display how many medals each athlete has got

[XOR LX]

Thanks. If you're not concerned about which medals they got, simply:

=COUNTIF($A$2:$E$37,B2) in H2 and copy down.

Regards

[Andrias14]

dude you're a champion thanks soo much :D

[XOR LX]

You're welcome. Did I get Gold?

[Fotis1991]

. Did I get Gold?

And 10000$ as prize!!

[Andrias14]

You're welcome. Did I get Gold?

HAHAHA love the joke, and yes you did

[Andrias14]

but this won't be the last time you hear from me

[XOR LX]

"And 10000$ as prize!!"

Great! Think I'll come and retire on a Greek island somewhere then, Fotis!

[Fotis1991]

"And 10000$ as prize!!"

Great! Think I'll come and retire on a Greek island somewhere then, Fotis!

I'll do my best to find a cheap and nice one.. Which will be my prize?

[XOR LX]

Your prize is that you get to have sunshine for more than two consecutive days in summer...

[Fotis1991]

Your prize is that you get to have sunshine for more than two consecutive days in summer...

You mean for more than two consecutive months of course..

Yes i am lucky!