Conditional Running total - only sum once when Invoice number changes

[Lynn KG]

I have a worksheet with sales of items by invoice number. Each item is a separate row, so there can be several rows with the same invoice number. I need to total sales for each invoice, only when the invoice number changes.

Invoice number in Column A, Ext. Price amount in column E, Shipping amount in column F and invoice total in G.
right now I put in a formula for each invoice. How can I automate this so when the Invoice number changes, It sums the of Ext. Price & Shipping for all rows with that invoice #.

invoice# Item Units Price Ext. Price Shipping Total
41280 1063F 3 $75.00 225.00 - 225.00
41281 1090F 2 $10.00 20.00 -
41281 1098F 1 $25.00 25.00 -
41281 3028F 4 $25.00 100.00 30.00 175.00
40416 1200F 1 $25.00 25.00 -
40416 6071F 2 $10.00 20.00 -
40416 1081F 3 $25.00 75.00 - 120.00
41291 4030F 1 $25.00 25.00 -
41291 4029F 1 $30.00 30.00 40.00 95.00
545.00 70.00 615.00
THANKS!

 

[Andrew Poulsom]

Welcome to MrExcel.

Have you tried eg?

=IF(A2<>A3,SUMIF(A:A,A2,G:G),"")

 

[Lynn KG]

Welcome to MrExcel.

Have you tried eg?

=IF(A2<>A3,SUMIF(A:A,A2,G:G),"")

Awesome! Thank you!!
Is it possible to sum both Column G and Column F, the Ext Price and Shipping?

 

[Andrew Poulsom]

Only by addition of SUMIFs:

=IF(A2<>A3,SUM(SUMIF(A:A,A2,E:E),SUMIF(A:A,A2,F:F)),"")

 

[Lynn KG]

Works like a Dream. You made my Day!
Thanks!!!!