will2learn
Board Regular
- Joined
- Dec 1, 2005
- Messages
- 144
Is it possible to make the formula below simpler so that it can run faster? The spreadsheet I'm currently using consists of a large number of formulas and I'm sure this is slowing the spreadsheet down.
I cannot turn off autocalc as so many calculations are needed elsewhere.
=SUMPRODUCT((Sales!$A$4:$A$360=Options!$D$14)*(Sales!$B$4:$B$360=D$5)*(Sales!$C$3:$J$3=$C$6)*(Sales!$C$4:$J$360))
I cannot turn off autocalc as so many calculations are needed elsewhere.
=SUMPRODUCT((Sales!$A$4:$A$360=Options!$D$14)*(Sales!$B$4:$B$360=D$5)*(Sales!$C$3:$J$3=$C$6)*(Sales!$C$4:$J$360))
