SUMIF too slow

Hello all,

So I am taking multiple tables and compiling them to a master table that contains all their information. Currently I am doing this via =SUMIF(A:A,"1,2,3etc",B/C/D:B/C/D). The problem is I need to do this for each individual line over and over again which means I have to type that out 150+ times. Is there a faster way to do this?

Please post a sample sheet ( see yellow banner)

Originally Posted by arthurbr

Please post a sample sheet ( see yellow banner)

Sure thing

the SUMIF is very quick function but you call it very many times

Please Login or Register  to view this content.

and its always slow. For my opinion the alternative is PowerQuery.
Or piwot table and

Please Login or Register  to view this content.