In article ,
"T. Valko" wrote:

You don't need to use an array formula to do this.

Well, technically SUMPRODUCT() *is* an array function (one reason you
can't use entire columns pre-XL07). You just don't have to use
CTRL-SHIFT-ENTER with it.