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
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
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
A | B | C | D |
PO# | Part # | Line Total | Order Total |
SHOP1 | A | 16897.55 | 36864.55 |
SHOP1 | B | 14789 | 36864.55 |
SHOP1 | C | 5178 | 36864.55 |
SHOP2 | A | 522 | 522 |
SHOP3 | A | 13954 | 13954 |
SHOP4 | A | 1800 | 1800 |
SHOP5 | A | 360 | 1137 |
SHOP5 | B | 1914 | 1137 |
SHOP6 | A | 991.27 | 99.27 |
SHOP7 | A | 439 | 6321.73 |
SHOP7 | B | 4172.73 | 6321.73 |
SHOP7 | C | 1710 | 6321.73 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>