sum of values based upon duplicate values in adjacent cell

[DoctorAwesome]

Hi all.

I am building a spreadsheet to calculate to total value of items that have been assigned a specific code. I want to be able to sum the cells in (for example) column D that have the same code in column A. I'm thinking maybe SUMIF would work but I'm a little stumped.

Thanks

 

[kdave]

You may want to look into a SubTotal function.

 

[Asala42]

The standard sumif will look like this:

=SUMIF($A$2:$A$1000,"1001001",$D$2:$D$1000)

where:
$A$2:$A$1000 is your column of codes
"1001001" is the code you are looking to match against. It could also be a cell reference rather than a distinct entry in quotes.
$D$2:$D$1000 is the range you want to sum when your criteria is met.

Hope that helps.