How do you successfully calculate multiple ranges and criteria using
SUMPRODUCT, i have just started using SUMPRODUCT on a regular basis and starting to
understand the power of using it, i do find difficulty calculating figures for an offset
of text over non contiguous ranges is there an easy way to achieve it or remember how to
formulate it?
This will be the base question for an ongoing tutorial kindly offered by xld, for those of you that don't know xld (www.xldynamics.com) has written the definitive tutorial and example uses around SUMPRODUCT rather than using array formulae that need to be committed with Ctrl+Shift+Enter.