Add cells on a few lines, according to value in cell#1!

[user123999]

Will try to explain! I have a calc file (55000 lines). In each line, cell #1 contains an URL. Next cells (let’s say Cell2 cell3 cell4) contain various values (stats). Some lines contain the same cell #1 but various values in other cells.

I need to know the total stats by URL, it means group all lines that have the same URL, and get the sum(cell2), sum(cell3) and sum(cell4).
Finally a new line should contain URL newcell1 newcell2 newcell3, with URL unique (no other line will have the same URL in cell1)

I sorted the table by the first cell, but after, don’t know what to do!

Any help? Thank you!

[JohnSUN]

Now choose Data - Subtotals or Insert - Pivot Table

[user123999]

Sorry, don’t understand how those functions can help

[JohnSUN]

Which of them? Subtotals? Or Pivot Table? Both of them can group rows by value in first cell and calculate some functions for other cells. For example, SUM() for each URL

[user123999]

Great, Subtotals is what I needed, thank you very much!!