FORMULA TO ADD ROW

[DFarrar]

I have a spreadsheet that I need to automatically insert a row after each
different invoice #,as my spreadsheet lists each item on the invoices. Then
I need to automatically total the amounts of the items for that invoice. Is
this possible?
DATE ITEM INVOICE # AMT
05/01 A 1234 25
05/01 B 1234 30
05/02 A 4321 25
05/02 C 4321 10
05/02 D 4321 15

 

[Domenic]

First select your data, then on the menu bar select...

Data > Subtotals

....and make the appropriate selections.

 

[DFarrar]

Thank you so much. This was perfect!

First select your data, then on the menu bar select...

Data > Subtotals

....and make the appropriate selections.

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions