Sales agents and targets

[PhilKib]

Hi

I hope someone can help me with an issue I'm having with a spreadsheet I have. In the book, I have a list of sales agents and on a daily basis each sale is recorded against each agent on the list. The information is fairly straight forward in that just the value of the sales is recorded, but there will be multiple entries from each agent over the course of the day. So for example, one agent may have 12 sales recorded.
On sheet1, there is a list of recorded sales for the day (agents name and value of sale) and on sheet2 I would like to have a drop down menu to select each agent in A1, and in B1 record their sales for the day.


Thanks for your help!

Phil

 

[AliGW]

Do you mean total sales for the day?

 

[Airfix9]

Assuming salesman name in column A and sale value in column B on Sheet1 and Salesman name in cell A1 of Sheet2, to show total value in cell B1 of Sheet2:

=SUMIF(Sheet1!A:A,A1,Sheet1!B:B)

 

[PhilKib]

Yes, sorry, its the total for each sales agent per day, the entries are not 'uniform' they are inputted as they are made.

Phil

 

[PhilKib]

Spot on mate! thanks very much!

Phil

(so simple when you take a step back!, thanks again!)

 

[Airfix9]

Welcome.