+ Reply to Thread
Results 1 to 3 of 3

VBA Multiplication of Two Columns

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    VBA Multiplication of Two Columns

    Hello, I understand this is a basic question but I was wondering if there was a short way to multiply two numbers on the same row (e.g. A1 & B1) and repeat this for as many columns as there is data in them (it can vary so could be A6*B6 OR A3*B3).

    So if there is data in a1 & b1 all the way down to a6 & b6 I want all the individual columns to multiply eachother and then possibly present the total value of each added together
    Last edited by lesoies; 10-06-2012 at 02:45 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Multiplying two cells on a row for the whole column and showing the total value

    in c1 = a1*b1 and drag down.

    Then you can use sum to sum the column C.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    N/A
    MS-Off Ver
    Excel 2010
    Posts
    218

    Re: Multiplying two cells on a row for the whole column and showing the total value

    Sorry I forgot to state I am trying to do this in a macro using VBA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1