Prior to XL07/08, SUMPRODUCT, like all other Array formulae (though you
don't need to use CTRL-SHIFT-ENTER), cannot be used on entire colums.

In article ,
jimd wrote:

Thanks, that worked as long as I didn't use A:A, A1:A100 works. must be the
range is too big.