Sum column in multiple worksheets

[Yorelsemaj]

Assistance please!

I know there is a way to sum a cell value in the same address in different worksheets: =SUM(Sheet1:Sheet3!B2).

This is assuming the items are aligned exactly in Sheet1, Sheet2 & Sheet3 as outlined below:
ColA ColB
Item Qty
1001 10
1002 50
1003 35
1004 25

Formula: =SUM(Sheet1:Sheet3!B2); Result: 30

What if however, in Sheet3 the sort order was different for ColA:
ColA ColB
Item Qty
1004 25
1003 35
1002 50
1001 10

How would I achieve the same result?

 

[T. Valko]

Valko.

You have been more help than I anticipated. Thank you for sharing your knowledge and expertise. Keep us the good work my friend.

Regards.

You're welcome. Thanks for the feedback!