+ Reply to Thread
Results 1 to 5 of 5

Horizontal Sum Product

  1. #1
    Registered User
    Join Date
    04-15-2008
    Posts
    17

    Horizontal Sum Product

    Good Afternoon All

    I have attached an excel file to illistrate

    I am wanting to sum the product of several pairs of columns to a cell right at the end. The problem is when i need to add more pairs of columns (Stock 4, Stock 5, Stock 6) etc, it will become extremely painful to add. I feel that a SumProduct is the way to go, however i cannot see how to get it to work in this situation.

    I would appreciate any assistance to make the resulting formula easier to program when adding additional stocks will be easier.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Horizontal Sum Product

    Try

    =SUMPRODUCT(($D$3:$H$3="Units")*$D5:$H5*$E5:$I5)

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,711

    Re: Horizontal Sum Product

    Try this array formula:

    Please Login or Register  to view this content.
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

  4. #4
    Registered User
    Join Date
    04-15-2008
    Posts
    17

    Re: Horizontal Sum Product

    Thank you. both work like a charm

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Horizontal Sum Product

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 11-09-2014, 02:08 AM
  2. Replies: 9
    Last Post: 10-16-2014, 07:46 AM
  3. Replies: 2
    Last Post: 09-10-2014, 08:56 AM
  4. [SOLVED] I'm receiving a Run-Time error 1004 while trying to delete a product from a product list.
    By redsab in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2014, 10:03 PM
  5. [SOLVED] Copying and pasting Horizontal Data to Horizontal cells
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2013, 01:14 AM
  6. [SOLVED] Find Product Details in Another Sheet based on Product ID and Copy some Fields From there
    By kevalkothari in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-29-2012, 10:43 AM
  7. [SOLVED] Need Function that will find ordered product, and display the product code in a 2nd workbk
    By rollerden in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2012, 08:52 AM

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