Hi Roger,
Don't bother, I tried it myself. A:A in the SUMPRODUCT gives the #NUM
error.
This is a first for me, I've managed to come up with a formula that has
an advantage over the SUMPRODUCT version, my formula doesn't need any
address adjustments.

Ken Johnson