Use a combination of SUMPRODUCT and XLOOKUP functions. SUMIFS won't work here because it only operates within a single range.

The key is to have a common key to link the tables, such as an article number or ID. XLOOKUP will find and substitute the required criteria from the second table, and SUMPRODUCT will sum the values based on all three conditions.

For complex cross-table summaries, it's important to understand the key differences between XLOOKUP and VLOOKUP, which make the new function more flexible and reliable.

🔗 Source: excel.rf