Two dimensional (2D) SUMIF / SUMPRODUCT across multiple worksheets?

[formulaic]

Hi all,

I have some data that is not consistent across multiple worksheets (fun!), meaning that the rows and columns don't always match up nicely. Is there a way to do a two-dimensional SUMIFS (or SUMPRODUCT) that would match both the row and column headers given, then sum up the total across multiple worksheets?

I know I might be approaching VBA territory here..

I've attached a workbook, the results in COL B are only accurate because "USA" is there throughout all worksheets, but Germany & Japan aren't.

Thanks!

[formulaic]

Bump.. anyone?

[NBVC]

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied across matrix.

Adjust ranges to suit first.

N.B. method adapted from Domenic (forum guru).