How to sum cells of separate sheets

[ngoundla]

Hi all,

I am trying to sum the values in separate sheets, please help me.

I already attached the sheet for your information.

Just i want to sum the "Sheet2" and Sheet3" values available in "B" and "C" colum based on the "Products".

In sheet1 I should get total sucess and failures for each prodcuts.



Thanks in advance.

[FDibbins]

Hi and welcome to the forum

If your data will always be in that exact same format across the sheets, use this, copied down and across...
=SUM(Sheet2:Sheet3!B2)

[ngoundla]

Thanks dear for your quick reply.

How about if the products are not same across the sheets??.


Thanks,

[XOR LX]

Hi,

Will it only ever be two sheets across which you wish to sum? Or could there be potentially many more?

Regards

[ngoundla]

Hi,

Yes, I wanted to sum the across these two sheets.

Some times I do encounter where the products across all the sheets are not same.

Thanks,

[XOR LX]

If there's only ever to be two sheets, there's probably not much point in setting up a dynamic, Named Range solution. In B2 and copy across and down:

=INDEX(Sheet2!$B$2:$C$6,MATCH(Sheet1!$A2,Sheet2!$A$2:$A$6,0),MATCH(B$1,Sheet2!$B$1:$C$1,0))+INDEX(Sheet3!$B$2:$C$6,MATCH(Sheet1!$A2,Sheet3!$A$2:$A$6,0),MATCH(B$1,Sheet3!$B$1:$C$1,0))

Regards

[ngoundla]

wow!

Working fine.

Thank you very much.

W