Sum cells based on value in adjacent cell

[balston2]

Hello,

I have a spreadsheet with data starting in column D. In column C I have codes that represent the type of data. I have extracted the unique codes to a new location and would now like to sum the cells in column D that have the same codes in column C. Example:

C D
00dh 12
00rh 11
00dh 6
00gh 88
00gh 14



00dh 18
00rh 11
00gh 102


I hope this makes since. Please Help!

Thank you!

[daddylonglegs]

If you have a specific code in F2 then try SUMIF like this

=SUMIF(C:C,F2,D:D)

you can copy the formula down the column

[balston2]

Thanks so much! Got it!