Cross product

[TR]

I want to find the sum of the products of the numbers in column A and
column B. Is there a cleaner way to do that then creating column C
with the products and then summing column C?

TIA

 

[Pete Loughborough]

I want to find the sum of the products of the numbers in column A and
column B. Is there a cleaner way to do that then creating column C
with the products and then summing column C?

TIA

Use the =Sumproduct function.

 

[Bob Greenblatt]

I want to find the sum of the products of the numbers in column A and
column B. Is there a cleaner way to do that then creating column C
with the products and then summing column C?

TIA

Use the sumproduct function, or an array formula, something like:
=sum(a1:a100*b1:b100) use control-shift-return to enter the formula. When
properly array entered, Excel will place braces {} around the formula -
don't type these.

 

[TR]

Thanks to both who provided answers. I knew there was a function there
somewhere. Searching help on "cross product" didn't get it for me.

TR