How to insert a row and auto sum by item type

[excelzen]

How can I automatically insert a row after each item type in column A to auto sum their totals in column I?

10096 9
10366 20
10366 29
10366 23
10370 20
10370 5
10370 13
10370 80
10370 10
10370 11
10370 29
10385 20

 

[Simon4s]

How can I automatically insert a row after each item type in column A to auto sum their totals in column I?

10096 9
10366 20
10366 29
10366 23
10370 20
10370 5
10370 13
10370 80
10370 10
10370 11
10370 29
10385 20

not sure what youre asking

 

[Joe4]

One easy way is to use the built-in Subtotals feature, which will allow you to insert subtotals at every change in column A, and sum up column B for each different value in column A (which sounds like what you are looking for).