Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Milford, Connecticut
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Lookup function help (Excel 2003)

    I admit to being a novice with formulas, etc. in Excel.

    I have a spreadsheet with a lot of data. I need to be able set up a summary page so I can list out the staff members and then have the total of their sales in the next column, by quarter.

    I would appreciate any help anyone can give me.
    Thanks

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup function help (Excel 2003)

    I am afraid we would need to see the workbook to help with that question. Could you attach a stripped down version that shows two or three staff members with dummy names and data, and a second sheet that shows what you want to see?
    Legare Coleman

  3. #3
    Star Lounger
    Join Date
    Dec 2001
    Location
    Milford, Connecticut
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup function help (Excel 2003)

    I've attached a dummy, very simplified spreadsheet.

    On the second tab is the 'data'. I need to summarize it, by using a formula, on the first, summary, page.

    I'm guessing there must be some type of If (james) then sum the amounts for him in the specified cell. That's what I'm looking for.

    Wish I could explain better, but I'm a true novice at these type of formulas.

    Thanks again for the help.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup function help (Excel 2003)

    Does this do what you want?
    Legare Coleman

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Lookup function help (Excel 2003)

    Enter the following formula in cell B3 on Sheet2:

    =SUMIF(Sheet1!$A$2:$A$10,A3,Sheet1!$B$2:$B$10)

    Use the fill handle to fill this formula down as far as needed. The SUMIF function has 3 arguments:
    - The column in which to look up the search value (the list of names)
    - The search value ("James")
    - The column containing the values to be added

  6. #6
    Star Lounger
    Join Date
    Dec 2001
    Location
    Milford, Connecticut
    Posts
    80
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Lookup function help (Excel 2003)

    That's it!

    Thank you so much.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •