+ Reply to Thread
Results 1 to 6 of 6

Matching names to items in a list and summing prices

  1. #1
    Registered User
    Join Date
    08-06-2015
    Location
    Bristol, England
    MS-Off Ver
    2014
    Posts
    3

    Matching names to items in a list and summing prices

    I have constructed an excel sheet with different groups of people where each person selects an item from a list drop down list (the main list is situated next everyone's names and their selection). I have then created IF functions to put the name of the person next to the item selected in the main list. My problem is that in the main list each item has a price and I want to have a cell underneath peoples names that gives the sum of the price of the items the people have selected. What sort of function would I be using to do this?

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,216

    Re: Matching names to items in a list and summing prices

    Please post a small sample file showing required results.

    Click "Go advanced" then Paper Clip icon to Upload a file.

    Thank you.

  3. #3
    Registered User
    Join Date
    08-06-2015
    Location
    Bristol, England
    MS-Off Ver
    2014
    Posts
    3

    Re: Matching names to items in a list and summing prices

    I have attached a copy of the excel sheet.
    Attached Files Attached Files

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,067

    Re: Matching names to items in a list and summing prices

    OK. Go with this, maybe??

    =SUMIF($D:$D,R$1,$C:$C)+SUMIF($H:$H,R$1,$G:$G)+SUMIF($L:$L,R$1,$K:$K)+SUMIF($P:$P,R$1,$O:$O)
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  5. #5
    Registered User
    Join Date
    08-06-2015
    Location
    Bristol, England
    MS-Off Ver
    2014
    Posts
    3

    Re: Matching names to items in a list and summing prices

    Thank you for your help! This works perfectly.

  6. #6
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,067

    Re: Matching names to items in a list and summing prices

    You're welcome... and thanks.

+ 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: 1
    Last Post: 03-18-2014, 02:19 PM
  2. how to make a check list that send items to a new sheet with prices
    By Teejmonster89 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2012, 02:34 AM
  3. Update Prices on price list and ID and add New Items - Multiple Product Lines
    By KNS Brakes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-26-2011, 09:50 AM
  4. Summing of items in a list
    By portsample in forum Excel General
    Replies: 1
    Last Post: 07-07-2010, 03:05 AM
  5. Matching prices for shopping items
    By samlim in forum Excel General
    Replies: 3
    Last Post: 01-04-2010, 04:20 AM
  6. Replies: 1
    Last Post: 12-18-2007, 01:59 PM
  7. Help...Summing Items Scattered in a list
    By modicon2 in forum Excel General
    Replies: 1
    Last Post: 08-21-2006, 11:45 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