Adding totals by name on separate worksheet

**mike519** · 10-25-2010, 12:10 PM

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

**JBeaucaire** · 10-25-2010, 12:21 PM

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.

**MarvinP** · 10-25-2010, 12:32 PM

Pivot tables may be another answer for you.

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

**mike519** · 10-25-2010, 06:05 PM

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.

**MarvinP** · 10-25-2010, 07:00 PM

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.

**JBeaucaire** · 10-25-2010, 07:03 PM

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

**mike519** · 10-26-2010, 04:23 PM

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.