Hi Ken

Unfortunately, Sumproduct will not take whole columns as arguments, but,
rather perversely, it will take whole rows (1:1).
You have to specify the range, it could be $A$2:$A$65536, or anything shorter.
Personally, I try to use dynamic named ranges that apply to the set of data
required rather than using cells references.

Bob Phillips has a very good treatise on Sumproduct at his site which you
will find very useful
http://xldynamic.com/source/xld.SUMPRODUCT.html

Regards

Roger Govier


Ken Johnson wrote:
See what I mean!
Roger's formula is shorter!
One day soon I'm gonna get my brain around that nifty little SUMPRODUCT
function!
I wonder Roger, can A:A be used in your formula instead of
$A$2:$A$whatever?
I was originally using $A$2:$A$9 and was going to tell tx12345 to
change it to suit the table, then I noticed A:A gives the same result
in my suggested formula. I know it's not important, I'm just curious.

Ken Johnson