+ Reply to Thread
Results 1 to 6 of 6

Sum Product Help:

  1. #1
    Registered User
    Join Date
    02-04-2013
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    8

    Sum Product Help:

    Hello,

    What I am trying to do is hard to explain, but an example will help:

    I am trying to multiply two cells together that are in the same row, then add that product to the product of the same cells just in the row below it

    . AB

    1 20 .10

    2 40 .25

    3 10 .5
    _______________________
    4 Total X



    I have attached another example with the highlighted portion being the total line, also the data set that I am trying to run this on has multiple columns and rows so it is not possible to add in a column to the left and add the sums

    All help is appreciated,

    Regards
    Attached Files Attached Files

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

    Re: Sum Product Help:

    Please add the desired result in the file.
    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
    Registered User
    Join Date
    02-04-2013
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Sum Product Help:

    Quote Originally Posted by oeldere View Post
    Please add the desired result in the file.
    Added, but that is the long way of doing it. If you know of a way quicker way, there is 220 rows in the original file.
    Attached Files Attached Files

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Sum Product Help:

    Based on your uploaded file the formula
    Please Login or Register  to view this content.
    will produce the same result as the result in cell F14

    Alf

  5. #5
    Registered User
    Join Date
    02-04-2013
    Location
    New York, New York
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Sum Product Help:

    Thanks Alf!


    I think I tried that before and for some reason it didn't seem to get me to the right answer...

    but now it does!

    Regardless thank you for the response and help

  6. #6
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Sum Product Help:

    Glad to be of help.

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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