Deb

=SUMPRODUCT(A1:A65535,B1:B65535) in C1

For more on SUMPRODUCT see Bob Phillips' site

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Gord Dibben Excel MVP


On 26 Nov 2004 17:08:00 -0800, (Deb B.) wrote:

I want to multiply one column by the next one to produce a product in
the third column. Is there a formula that does this in one step?
Thanks,
Deb