Sum cells if adjacent cells are the same

[SpartanMike]

Hello all,

Brand new to the forum so apologies in advance for any missteps.

I am trying to consolidate some data in a 400 row spreadsheet with about 20 columns. What I am looking for is a formula that will Sum all dollar values in column B (highlighted in blue) IF the value in column C (highlighted in green) is the same. In theory, all other data in the row should be the same, so only these two cells are of concern. Is there a way to sum the data highlighted and reduce the number of rows per unique entry in column C to a single row? I have tried looking through SUMIF options but haven't been able to make progress.

Hopefully an image of what I'm describing is attached here:

SumCells.jpg

Thanks in advance!!!
Mike

[TMS]

Try a Pivot Table.