Checking data and then summing up the total

[rusoo7]

I have a list of people’s names with an amount of money they are going to take. So for example A2 contains Data B2 contains the Name and C2 contains the amount. Now B2 is going to repeat it’s self because the person worked on different days. The name of the person will always be the same so can be set as a variable. =IF(B2:B50="Name",SUM(C)) and then after that i lost. Could someone help me finish this formula? Huge thanks in advance.

[DonkeyOte]

see SUMIF

=SUMIF(B2:B50;"Name";C2:C50)

If you wish to repeat for all names you should consider using a Pivot Table with Name as Row Label and Col C Field as Data Field set to SUM.

[royUK]

You might be able to use a PivotTable

[rusoo7]

see SUMIF

=SUMIF(B2:B50;"Name";C2:C50)

If you wish to repeat for all names you should consider using a Pivot Table with Name as Row Label and Col C Field as Data Field set to SUM.

Thank you DonkeyOte ... this does exacly what i wanted. I only have 5 names to worry about so its not anything complicated and i'm not sure how the Pivot Table works. I'm still some what new to this but I learn something new every time I visit this forum. You guys are wonderful!