# Thread: Lookup function help (Excel 2003)

1. ## 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. ## 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?

3. ## 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. ## Re: Lookup function help (Excel 2003)

Does this do what you want?

5. ## 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. ## 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
•