Function

  • Thread starter Thread starter Dale Marques
  • Start date Start date
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.
 
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)
 
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiply Corresponding Values in Range 3
Excel print area which only prints pages of worksheet which are active 0
Array with many cells from a row but not in order or together 11
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Identifying the worksheet and cell that contains a function call 3
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
VBA set thick borders around non empty cells in range 0
Taking the 51st Line and Multiplying by 2 8

Back
Top