SumProduct works but locks my laptop, need something less memory intensive

[lost_in_the_sauce]

FYI It's a Lenovo with a 1.8Ghz i7 and 16 GB Ram.

Consolidating numbers on sheet 1 from sheets 3-5 using sheet 2 as a map so I can just dump new data to sheets 3-5 as it is delivered.

Sheet 2 has about 400 account names in column A that correspond to categories in column A on sheets 3-5
Sheet 2 has a data validation list drop down in column C of about 15 rollups so every account on column A can be assigned a rollup.

This is the formula I'm using just to sum one month's worth of data to sheet one and it absolutely locks my laptop:

=sumproduct(sumifs('sheet 3'!B:B,'sheet 3'!$A:$A,'sheet 2!$A:$S,'sheet 2'!$C:$C,'sheet 1'!$B3))

It works, it sums column B if whatever is in column A has the right rollup next to it on sheet 2, but it stops everything. And I haven't even copied into the other cells or had it look at sheets 4 or 5 yet. Am I putting too much calculation requirement on sumproduct?


New work laptop so I'll have to ask IT if I can install XL2BB, it won't be today, still waiting on software I need to do my job basics

 

[Fluff]

Do not use whole column references. Limit the ranges to something sensible.

 

[MARK858]

Try changing the ranges so you aren't referencing entire columns, even if it is something like A1:A200000