Good morning. I need Column C be populated based off the following:
The sum of Column A and B need to be to populated in the last row of column C for the total of each Order Number in Column D.
In other words C6 will be the total of A2:B6. C7-C9 needs to be blank, so I'm thinking (iferror then blank). C10 will equal the sum of A10:B10. C11 will be blank and C17 should be the sum of A12:B17, etc.
The sum of Column A and B need to be to populated in the last row of column C for the total of each Order Number in Column D.
In other words C6 will be the total of A2:B6. C7-C9 needs to be blank, so I'm thinking (iferror then blank). C10 will equal the sum of A10:B10. C11 will be blank and C17 should be the sum of A12:B17, etc.