Need help to count number of rows with same value and copy that sum multiple times as value in another cell

[ea2146]

Hello,
I have a problem that has stumped me. I would be eternally grateful if someone could help me.
Problem: “total_members” value does not include people with “Name” of “AAA”. For example, in expedition #2, you can see that total members is listed as 4, when it should say 5. However, not all expeditions are incorrect. For example, expedition #1 has no errors because there are no members with name “AAA”. Complicating things further, some expeditions have more than one “AAA” member. For example, expedition #6 has two “AAA” members and therefore, the total members for expedition #6 should be 3 instead of 1. In short, I need the values in the “total_members” column to reflect the total number of names in the “Name” column for that expedition. Currently, the “total_members” column = (total members - # of “AAA”s). Does this make sense. I would really appreciate it if someone could provide a formula to correct this. Thanks so much!![TABLE="width: 375"]
<tbody>[TR]
[TD]Name
[/TD]
[TD]expedition
[/TD]
[TD]total_members
[/TD]
[/TR]
[TR]
[TD]Burton
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]5
[/TD]
[/TR]
[TR]
[TD]Crofts
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]5
[/TD]
[/TR]
[TR]
[TD]Halstead
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]5
[/TD]
[/TR]
[TR]
[TD]Moore
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]5
[/TD]
[/TR]
[TR]
[TD]West
[/TD]
[TD="align: right"]1
[/TD]
[TD="align: right"]5
[/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Lavish
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Metchetina
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Prokopenko
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]P****yn
[/TD]
[TD="align: right"]2
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Amann
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Amann
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Duenser
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Fritsche
[/TD]
[TD="align: right"]3
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Brown
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]6
[/TD]
[/TR]
[TR]
[TD]Fioretti
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]6
[/TD]
[/TR]
[TR]
[TD]Henshaw
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]6
[/TD]
[/TR]
[TR]
[TD]Lambert
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]6
[/TD]
[/TR]
[TR]
[TD]Lane
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]6
[/TD]
[/TR]
[TR]
[TD]Zangrilli
[/TD]
[TD="align: right"]4
[/TD]
[TD="align: right"]6
[/TD]
[/TR]
[TR]
[TD]Gonzalez Gonzalez
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Lopez Gros
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Pujol Ferrusola
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Rubiella
[/TD]
[TD="align: right"]5
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]AAA
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]Karlsson
[/TD]
[TD="align: right"]6
[/TD]
[TD="align: right"]1
[/TD]
[/TR]
[TR]
[TD]Buccella
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Cavallaro
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Feijoo
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
[TR]
[TD]Ogliengo
[/TD]
[TD="align: right"]7
[/TD]
[TD="align: right"]4
[/TD]
[/TR]
</tbody>[/TABLE]

 

[J.Ty.]

Enter

=COUNTIF($B:$B,B1)

into C1 and copy all the way down.

J.Ty.

 

[ea2146]

Thank you so much, J.Ty!! I really appreciate it.