Advanced COUNTIF problem (maybe!)

[kyjae]

Hi All,

I need some advice in extracting information and summations from a list. Here is the scenario in the file I've attached.

In column A, four persons have entered items into a competition. In column B, the points awarded to each person against that entry is shown.

Counting the number of entries of each person in column A is easy with the COUNTIF function. But in column F I want to sum the scores against each entrant in column B and display the result against each entrant's name down column F (e.g. take all the scores against Person_A from column B and total them to dispaly in F2.)

I've really drawn a blank on this. Any advice?

Thanks

[Lemice]

Hello,

Are you looking for a formula like this

Please Login or Register  to view this content.

Paste it on Cell F2 and drag it down

[brocktoon93]

A pivot table might be a good option too, but enter this formula into cell F2

=SUMIF($A$2:$B$12,"Person_A",$B$2:$B$12)

It will sum up the points in column B if column A says "Person A". Then copy this down, just change the Person. Is this what you needed?

[kyjae]

Thank for your replies.

Didn't realise the SUMIF function could do this. I'll try it out and come back if I have any more problems.