inverting data and multiplication

Joined
Nov 20, 2007
Messages
1
Reaction score
0
I have two columns of numerical data, not in any particular order:

A1 B1
A2 B2
A3 B3
... ...

For each row, I need to invert the values in column A and sum the products:

C1 = A1*B1
C2 = (A1*B2)+(A2+B1)
C3 = (A1*B3)+(A2*B2)+(A3*B1)

I can do this by creating a helper column and using INDEX and ROW functions, but I have to modify the function for each row. There are a couple hundred rows of data so that would be very time consuming.

Could someone help me out? Can I do this with just functions or do I need to use visual basic?

thanks
 

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

Top