Hi,
I was wondering if you could possibly help me out. I've got multiple tabs which use large sumproduct formulas to total up results specific to each location. Unfortunately my method of working out the formulas is causing an unacceptable slow down of the document which multiple people have to use.
Is there an alternative formula /method to work out the results? Obviously switching to manual calculation is an option, but it's one I want to avoid
In the attachment is one of the tabs, all formulas have been removed except for the offending columns in yellow which is causing the slow down. I think this one would be a good one for me to learn
Thanks for any help
Bookmarks