Help ! SUMIFS with 4 conditions and massive data - Fast and Light alternatives required

Dear All,

I've browsed the net and i've seen many users having similar issue but probably with different needs, in any case i could not find something that fit my needs.

Sheet1 --> raw data >100k rows in 10 columns so quite heavy DB
Sheet2 --> computations having SUMIFs within 4 conditions
Sheet3 --> some conditions of SUMIFs

This is my current formula which works beautifully but it's really too slow:
=SUMIFS(Transactions!$E$2:$E$1048576,Transactions!$C$2:$C$1048576,Computations!$K2,Transactions!$G$2:$G$1048576,Computations!L$1,Transactions!$J$2:$J$1048576,Settings!$L$2)

Solutions to exclude:
- SUMPRODUCT
- SUMIFs
- SUMIFs with OFFSET, INDIRECT, INDEX/MATCH
- DataTable
- DSUM

Hopefully someone can point out an efficient solution ! Thank you in advance !!!

Hi

Have you tried replacing $1048576 with a smaller range say 110000. It may speed it up a little.

Cheers