To sum up the total of one group having 2 and more than 2 columns and G/L Account

[PRADEEPB270]

Is there any excel formula to sum up the grand total of one group having 2 or more columns also G/L Accounts on other sheet ?

Please refer the attached file .

Regards

Pradeep Kumar Gupta

[teylyn]

Pradeep,

it might be helpful if you could come up with a few mocked up results and explain the logic that leads to it. I only see an awful lot of numbers and some formulas, but I have no idea what result you want and where the input comes from.

[PRADEEPB270]

I have different cost centre's code e.g.AAA2110,AAA2119 and so on,but their group is only 1.I want to sum up the total of these cost centres having the same group say 1 on the other sheet.

Regards

Pradeep Kumar Gupta

[teylyn]

Pradeep, you already have a formula that does that. What is the question?

[teylyn]

try in C5

=SUMPRODUCT(('CC-HHHD'!$B$5:$B$21=Sheet1!$B5)*('CC-HHHD'!$C$2:$L$2=Sheet1!C$2)*'CC-HHHD'!$C$5:$L$21)

copy across and down