+ Reply to Thread
Results 1 to 8 of 8

Adding totals by name on separate worksheet

  1. #1
    Registered User
    Join Date
    10-25-2010
    Location
    Waterloo, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    3

    Adding totals by name on separate worksheet

    Hi all,

    I have a worksheet where I need to be able to enter a name in one column then a sales amount in the next column and then on a seperate worksheet, show me the sum of all sales by name. I have tried setting up a drop down list where someone can choose from a list of names (there are about 15 possibilities) then enter the sales amount in the next column but don't know where to go from there to have the totals on a seperate worksheet.

    I am somewhat informed on excel but not an expert by any means so go easy on me.

    Thanks!

    Mike
    Last edited by mike519; 10-25-2010 at 06:01 PM.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Need help adding totals by name on seperate worksheet

    The SUMIF() function will do what you want, and it works easily from separate sheets.


    Please edit your title in post #1 and remove the "need help" as that is true of all posts.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,816

    Re: Need help adding totals by name on seperate worksheet

    Pivot tables may be another answer for you.

    http://www.edferrero.com/ExcelTutori...4/Default.aspx

  4. #4
    Registered User
    Join Date
    10-25-2010
    Location
    Waterloo, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Adding totals by name on seperate worksheet

    Sorry, I looked at the link but have no idea what a Pivot Table is.

    Can you elaborate on using sumif?

    If, on sheet 1, I have a column where names are selected from a drop down list and then the next column over has a spot where the user enters a sales number, but the user could have multiple entries on the worksheet for the same drop down list name, can you run me through a script that would take all the results from name 1, name 2, name 3, etc and give me a total by name on the next worksheet?

    Thanks for your help.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,816

    Re: Adding totals by name on separate worksheet

    Hi Mike,

    You should look at a few videos like:
    http://www.bing.com/videos/watch/vid...KVR5&FORM=LKVR
    or
    http://www.bing.com/videos/watch/vid...0tables%202003 Which is very close to your question.

    Watch these two videos. You could also upload a sample file that we could do it for you as an example.

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Adding totals by name on separate worksheet

    Press F1 in Excel read the builtin tutorial on SUMIF(). It should answer all your questions about how it used.

  7. #7
    Registered User
    Join Date
    10-25-2010
    Location
    Waterloo, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Adding totals by name on separate worksheet

    OK, trying Pivot Tables and got the wizard running and had it create a table ona seperate worksheet. Great videos BTW, thanks!

    Kinda stuck though as I am not sure where to go from here. I can get the Names showing up in the table as I want but not the totals associated with that particular name. I am attaching the file as suggested for anyone wanting to help a total rookie solve this. I know a little excel but its still more than anyone else I work with does so I have been delegated to doing this but I know I'm a long way from you pros so any help is muchly appreciated.
    Attached Files Attached Files

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,816

    Re: Adding totals by name on separate worksheet

    Hi Mike,

    Glad you liked the videos. Here is your table back with two pivot tables on it. Click on the Pivot Table and see you can make sense of it.
    Attached Files Attached Files

+ 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