Sum data from 2 sheet.

[fairyme]

I have 3 sheets in file (CC,CE,SUMMARY)

I want sum value (column BCV_Transaction ,BCV_AMOUNT) from sheet CC and CE (refer by column Company_Group) to sheet summary


Please guide me for solve it (VBA , macro or formular)

Thank you

[Glenn Kennedy]

Your expected results are frequently incorrect.

=SUMIFS(CE!D:D,CE!$A:$A,$A2,CE!$C:$C,$C2)+SUMIFS(CC!D:D,CC!$A:$A,$A2,CC!$F:$F,$C2)

copied across and down.