Guidance with adding cells that only fall into rows that contain certain information

[mikeoo]

Hello,

I need a little guidance with adding cells that only fall into rows that contain certain information. I know that may sound a little confusing , so let me just jump straight to an example.

In reference to the picture below, I’m looking to have Bob and Joe’s “amounts” automatically totaled in the box to the right hand side, without having to manually sort and select each person. Any help with achieving this is much appreciated! Thank you!

Capture.JPG

[Masa1989]

Sumif(D:D,"Bob",C:C) in cell F3 and Sumif(D:D,"Joe",C:C)

[ChemistB]

If you just put the names into F3 and F4, you can simplify anzafsa's formula and your effort with

=SUMIF(D:D, F3, C:C) copied down

[mikeoo]

Thank you both for the helpful information!!! Rep to you both! I hope you both have a great weekend!