I have a spreadsheet and it has data in columns A-K and what im trying to do is at every change of number in column A, I need to do an autosum of the values of data in column I and input the total into column J .

Lets say I have the same number in A1-A9 and I have values in Column I, When the number changes in A10 I need the data in I1-I9 all added together and then a total put in J9.

I then need this to repeat down the sheet. The same number in column A varies depending on how many entries there are.

Any ideas?