i have a number of sumifs formula with the same criterion range and criterion, like the following
=sumifs(sh2!r2c4:r8000c4,sh2!r2c3:r8000c3,rc1)
=sumifs(sh2!r2c5:r8000c5,sh2!r2c3:r8000c3,rc1)
=sumifs(sh2!r2c6:r8000c6,sh2!r2c3:r8000c3,rc1)
=sumifs(sh2!r2c7:r8000c7,sh2!r2c3:r8000c3,rc1,sh2!r2c5:r8000c5,">12")
as you can see the criterion range sh2!r2c3:r8000c3 and the criterion rc1 is the same in different sumifs formula, which cause repetitive calculation and slow it down.
anyone has a solution to improve the formula structure?
=sumifs(sh2!r2c4:r8000c4,sh2!r2c3:r8000c3,rc1)
=sumifs(sh2!r2c5:r8000c5,sh2!r2c3:r8000c3,rc1)
=sumifs(sh2!r2c6:r8000c6,sh2!r2c3:r8000c3,rc1)
=sumifs(sh2!r2c7:r8000c7,sh2!r2c3:r8000c3,rc1,sh2!r2c5:r8000c5,">12")
as you can see the criterion range sh2!r2c3:r8000c3 and the criterion rc1 is the same in different sumifs formula, which cause repetitive calculation and slow it down.
anyone has a solution to improve the formula structure?
Last edited: