Good evening to all of you...

Is it a challenge? Check this out

I would like to perform some calculations in a spreadsheet where I have a
matrix, for instance (column A= group, column b= subgroup, column C=turnover
and the values in A1=1, B1=3...)


A B C D E
1 1 3 100
2 1 3 100
3 1 2 50
4 1 2 50
5 2 1 100
6 2 1 100
7 3 2 100

I would like to create a summary table using a matrix and have the following

Group Sub Group Occurences Turnover
1 3 2 200 --> (C1=100
+ D1= 100)
1 2 2 100 --> (C3=50 +
C4= 50)
2 1 2 200
3 2 1 100

Is there a way using a matrix to calculate the turnover for a given
combination group / Sub/group.... I know how to calculate the occurence
using a matrix, I would like some help on summing the turnovers

Regards,

Michel