I have three columns with 1500 rows in this form:
Name codenb area X1 1 12 X2 1 8 X3 2 16 X5 3 2 X6 4 20 X7 5 5 ... ... .. Xn
Anyone have an idea on how can I calculate automatically the sum only of the rows that have the same codenb?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
By sum you mean the sum of the area?
You can use
For instance will give you the sum of all the
codenb equal to
B:B is the column with the criteria (column
1 is the
codenb that you're summing;
C:C is the column containing the values to sum.
If you want to get a table with a summary of all the
codenb and the sum of each group of areas, then a PivotTable will be easiest/fastest.
codenbin 'Row Labels' from the right pane;
areain 'Values' from the right pane;