Sum Range Based on Values in another Column

[data1]

I've got a table with several hundred rows each representing a different entry however several rows will share the same value in one particular column.

I'm trying to create a column (Column C) where the values equal the sum of all values in Column B for which the values in Column A are equal. In other words, I'm trying to define the range of a SUM Function as "all cells in a column where the cells in another column are equal"

chart 1.jpg

Any ideas on how I can approach this?

Thanks.

[oeldere]

sumif will do for you.

pivot table is another option.

[data1]

Thanks!

The SUMIF approach that you suggested worked!

The formula that I ended up using for my "C Column" (which in my actual table is Column AN is: =SUMIF($C$2:$C$849,"="&C2,$AM$2:$AM$849)
where the value in Column C was the relevent data, the criteria was to separate sums by similar values of C, and AM was the Column where I wanted my sums!)

Thanks again for your help!

[oeldere]

Thanks for your reply.

Glad I could help.