Group 2 columns and sum values for another column

Question

I have the following problem: I need to group data and perform a sum in another column in libreoffice calc/excel spreadsheet, just like a group by would do in SQL

In the following example, I would like the cells A26, A27 to become one line, and cell C26 should be the sum of the 2 rows.

Why not just use a pivot table? Or does it have to be in the same location / format as the original is? — Tim Edwards, Aug 03 '16 at 13:46

DeLuc · Answer 1 · 2016-08-26T14:53:38.290

0

Try on E26 cell the formula =($A26 & $B27) (Or =($A26 & (-$B27)) if you want a dash between A26 and B27).

And on F26 cell =($C26+$C27) for the sum of rows.

Copy/Paste for the other cells of each col

edited Aug 26 '16 at 14:53

answered Aug 24 '16 at 14:10

DeLuc

3
3

Group 2 columns and sum values for another column

1 Answers1