sum if formula across two worksheets

[lintru]

Hello,

I have sheet 1 called Daily Leads October and sheet 2 called Daily Leads November_December

In both sheets I have a list of products (10 different products) starting from cell B2 to B440 and I also have another column for total profit H2 to H440.

In another sheet what i want to do is find product A from Daily Leads October and Daily Leads November_December and to calculate the total sum of profit of this specific product from both sheets.

i have tried using the sum if calculations but it doesn't seem to work can anyone help?

Thanks

 

[nigelk]

You could always use 2 sumif added together. For example:

=SUMIF(B:B,"Pens",H:H)+SUMIF(Sheet2!B:B,"Pens",Sheet2!H:H)