Thread: how do I multiply two columns one by another? Thanks
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how do I multiply two columns one by another? Thanks
Thanks Sandy

"multiply" being the keyword


Gord

On Sat, 26 May 2007 12:06:48 +0100, "Sandy Mann"
wrote:

I think that Gord intended:

=A1*B1

but if you want to add all the results of the multiplications up without
having the results of the multiplication try

=SUMPRODUCT(A1:A100,B1:B100)

adjust the ranges to suit.

Reply With QuoteReply With Quote