+ Reply to Thread
Results 1 to 4 of 4

sum of products of a search for a value

  1. #1
    Registered User
    Join Date
    09-15-2016
    Location
    Derby, England
    MS-Off Ver
    2007
    Posts
    2

    sum of products of a search for a value

    Hi,
    I'm trying to search column A for a value, say 1 & then return a sum of the products in column B that are in the same row of the value 1

    I can't seem to attach anything yet, so


    A B
    1 10
    1 15
    1 20
    5 1
    6 10


    Cell E4 has the value of 1 - I need to search column A for the value of E4 & return the sum of the products in column B into the cell E5 e.g. sum = 45 in the example

  2. #2
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    70

    Re: sum of products of a search for a value

    I might be over simplifying, but does this cover it?

    Put this is E5
    =SUMIF(B2:B6,E4,C2:C6)

    E4 has a 1 in it and the result is 45, because it looks down column A and every time it finds a 1 it adds up what's adjacent to the 1 in column B.

    Entering 6 in cell E4 would return 10.

  3. #3
    Registered User
    Join Date
    09-15-2016
    Location
    Derby, England
    MS-Off Ver
    2007
    Posts
    2

    Re: sum of products of a search for a value

    That works great.

    Thank you so much for the speedy answer, it's very much appreciated

  4. #4
    Registered User
    Join Date
    12-11-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 365
    Posts
    70

    Re: sum of products of a search for a value

    Not a problem, sumif is a very useful formula - one for the kitbag.

+ 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: 8
    Last Post: 07-01-2016, 02:07 AM
  2. Replies: 6
    Last Post: 03-05-2016, 02:42 PM
  3. Search products below par and create an order list
    By Danimal39 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2015, 04:42 PM
  4. Search products below par and create an order list
    By Danimal39 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2015, 04:17 PM
  5. best way to search duplicate products on two excel sheet
    By intouch01 in forum Excel General
    Replies: 2
    Last Post: 08-01-2015, 12:51 AM
  6. Replies: 4
    Last Post: 12-16-2012, 04:33 PM
  7. Replies: 10
    Last Post: 10-26-2012, 04:10 AM

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