Sum If Cell Matches

[Mcook13]

Hello,

I am trying to sum a column based on matching PO#'s

My sheet has the customer PO# in column A, the part # in column B, that part#'s total dollar amount in column C, and in column D is where I would like it to total that PO in the cell in that column. Below is how I have it set up and in column D is what it should look like.

I think it would be a SumIF(s), but I can't figure out how to write it so it'll work.

Any help is appreciated


[TABLE="width: 289"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]PO#[/TD]
[TD]Part #[/TD]
[TD]Line Total[/TD]
[TD]Order Total[/TD]
[/TR]
[TR]
[TD]SHOP1[/TD]
[TD]A[/TD]
[TD="align: right"]16897.55[/TD]
[TD="align: right"]36864.55[/TD]
[/TR]
[TR]
[TD]SHOP1[/TD]
[TD]B[/TD]
[TD="align: right"]14789[/TD]
[TD="align: right"]36864.55[/TD]
[/TR]
[TR]
[TD]SHOP1[/TD]
[TD]C[/TD]
[TD="align: right"]5178[/TD]
[TD="align: right"]36864.55[/TD]
[/TR]
[TR]
[TD]SHOP2[/TD]
[TD]A[/TD]
[TD="align: right"]522[/TD]
[TD="align: right"]522[/TD]
[/TR]
[TR]
[TD]SHOP3[/TD]
[TD]A[/TD]
[TD="align: right"]13954[/TD]
[TD="align: right"]13954[/TD]
[/TR]
[TR]
[TD]SHOP4[/TD]
[TD]A[/TD]
[TD="align: right"]1800[/TD]
[TD="align: right"]1800[/TD]
[/TR]
[TR]
[TD]SHOP5[/TD]
[TD]A[/TD]
[TD="align: right"]360[/TD]
[TD="align: right"]1137[/TD]
[/TR]
[TR]
[TD]SHOP5[/TD]
[TD]B[/TD]
[TD="align: right"]1914[/TD]
[TD="align: right"]1137[/TD]
[/TR]
[TR]
[TD]SHOP6[/TD]
[TD]A[/TD]
[TD="align: right"]991.27[/TD]
[TD="align: right"]99.27[/TD]
[/TR]
[TR]
[TD]SHOP7[/TD]
[TD]A[/TD]
[TD="align: right"]439[/TD]
[TD="align: right"]6321.73[/TD]
[/TR]
[TR]
[TD]SHOP7[/TD]
[TD]B[/TD]
[TD="align: right"]4172.73[/TD]
[TD="align: right"]6321.73[/TD]
[/TR]
[TR]
[TD]SHOP7[/TD]
[TD]C[/TD]
[TD="align: right"]1710[/TD]
[TD="align: right"]6321.73[/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about
=SUMIF(A:A,A2,C:C)

 

[Joe4]

Try putting this in cell D2 and copy down to row 13:

=SUMIF($A$2:$A$13,A2,$C$2:$C$13)

 

[Mcook13]

Thank you. It worked!

 

[Fluff]

Glad we could help & thanks for the feedback