Sum based off variable

[GordonLS]

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.

 

[Fluff]

How about

=IF(COUNTIFS(D$2:D2,D2)=COUNTIFS($D$2:$D$1000,D2),SUMPRODUCT(($D$2:$D$1000=D2)*($A$2:$B$1000)),"")

 

[GordonLS]

Thank you . I will give this a run.

 

[Fluff]

Ok

 

[Eric W]

If your orders are grouped like your example, then this should work:

=IF(D2<>D3,SUMIF(D$2:D2,D2,B$2:B2),"")

This also assumes you have column C formatted with Accounting format, which also seems to be the case.