How to get the total sum

  • Thread starter Thread starter TPG
  • Start date Start date
T

TPG

I have data on Column A and B, I would like to total up a sum by multiply A1
to B1, A2 to B2, A3 to B3 and so on. But the sum must appear on the last line
of Column B.
(in this example is B5). Thank in advance.
A B
1. 5.00 25
2. 73.40 48
3. 86.70 60
4. 14.90 237
5. ???
 

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

Variable Sum Function 6
how to sum up a range of formulas? 5
progressive sum 3
Sum Total 2
Sum with Auto Filter On 2
Sum Array Range & Individual Cells 1
Sum Formula with variable range 2
Charts. 6

Back
Top