Function

D

Dale Marques

I need to write a program that calls a function and takes
2 ranges (which are selections) and multiplies them
together, and prints the results on a 3rd sheet. I am a
little lost.
 
B

Bob Phillips

Why a program?

=SUMPRODUCT(Sheet1!A1:A10,Sheet1!B1:B10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

I need to multiply corresonding cells together, the first
cell from range 1 and the first from range 2. Then
display the product of those two, and move on to cell two.
 
B

Bob Phillips

Not to labour the point, why not just put =A1*B1 in C1, and then copy down?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top