I am familiar with using SUMPRODUCT(--(criterion=range1),(range2)) to obtain
results not possible with SUMIF. However, I would now like to apply this to,
say, all D5 cells in many contiguous worksheets. I get error results. Can
someone confirm that this is not possible to do? Any suggestions for a way
around this?
Many thanks,
Stephen Powell