Need help with a Sales contest

[gbeethe]

So I've been tasked with recording sales results for our sales staff. Basically I have about twenty reps and I'll be putting in the details of their sales each day. What I need is for it to tally up totals for each sales person. I don't know if it be best to keep the running totals in a separate sheet. I used to use Excel a lot ten years ago and did a lot of things like this but I could use some reminding please.

 

[vmjan02]

well, not so sure as what you are looking for
but you can keep all your staff name in a different sheet, then use the functions

sumif or sumifs (both function will give you the total of sales for respective staff.

I hope this helps.

 

[johnnyL]

Are you adding up columns or rows?

 

[gbeethe]

Rows

 

[vmjan02]

well here is the example

I have sales details in sheet one and the total sales output with function in sheet 2 (sheet2 is name as "Emp")

yes only Rows

 

[gbeethe]

I'll be entering the stock number that's sold. The sales person who sold it, and the money they collected as a downpayment. The contest is to see who can collect most amount of money. Should be simple but I think I'm overthinking it.

 

[gbeethe]

So I might list 300 stock numbers that are sold. i'll be adding the appropriate sales person's name and the money they collected. I'll need to it add the totals per rep.

 

[vmjan02]

@gbeethe yes you are on a right path.

Good to know it did help you.

 

[johnnyL]

To add consecutive values in a row, in your TOTAL cell place something like the following:

= SUM(A1:A3)

That would total up Cell A1, A2, and A3, for example.

 

[gbeethe]

Yeah, I know how to add consecutive values. What I need is to add the values per rep. So say John Smith sells three units and he's listed on E9, E17, and E26. I would want to add F9, F17, and F26.