convert Sumifs to sumproduct or similar

Thanks XLent

This does exactly what I need it to do. The only problem I have now is if I convert my current spreadsheets to Tables it seems to break other things

is it possible to do the same but without making tables?

Thanks

Stephen

...is it possible to do the same but without making tables?

Yes, I just used Tables for sake of expediency -- if you were to highlight both Tables in my earlier attachment and "Convert to Range" you will find the master table simply references the now defunct table ranges explicitly
(obviously you can have non-volatile dynamic names if you need them to expand/contract as you add data, akin to Table behaviour)

I fully accept @JohnTopley's note regards prudent use of Volatiles however, IME on this board (over the years) I've seen enough examples of people complaining of calc overhead to advocate non-volatile alternatives wherever feasible - esp. as we only have a limited idea of the calc tree dependencies etc; the use of the SUBTOTAL field on each source range is always worthwhile as it greatly simplifies the calculation, irrespective of volatility concerns.