Vlookup?

P

Pete McCosh

I'm not 100% sure what you're trying to do, if it's just
multiply each group of two figures, then use:

=sumproduct(a1:a4,b1:b4)

Pete
 
A

an

Afirmative!
Many thanks
an
-----Original Message-----
I'm not 100% sure what you're trying to do, if it's just
multiply each group of two figures, then use:

=sumproduct(a1:a4,b1:b4)

Pete
.
Click to expand...
 

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

Mail Merge Switch - Dollars to Words 0
Use & with two formulas 2
Sumproduct giving #Value error 5
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Separating equal values 2
Percentage Formula Help 1
Lookup / Summary Table 0
multiplication of two array in a particular way 2

Top