Alternatives to Subtotal function in excel

Question

I need to total of 36,892 records, which I have to do. Excel crashes when I try to utilize the subtotal function because it can't handle the volume of data.

I need to put the data in column d for each update in column an in my 36,000 rows of data. Column a contains 1 to 10 duplicate records, depending on the case.

I've tried dividing it up into smaller data chunks, but it seems to only be able to handle roughly 5,000 at a time, which will take forever.

Is there another choice I could make?

Answer 1

In an unused column to the right put this formula in the second row and double-click the fill handle.

if(a2<>a3, sumifs(d:d, a:a, a2), text(,))