Hello!
thank you all for your assistance with this.
I am a sales manager and I have a Spread Sheet that keeps track of every sale my sales team makes. I need to find a way to automatically add each sales reps results automatically. I currently use the sort feature to isolate a particular sales rep and simply highlight the column with the sales $$ figures and look at the total in the bottom right of the screen (along with Average and count)
I need a way to have these sales figures for each of my reps automatically calculated.
My spreadsheet is set up the following way:
A B C
1 Rep Sales $$ School Name
2 Joe $3,584.34 Lincoln Elementary
3 Josh $5,684.44 Adams Elem
4 Mary $2,447.87 Jefferson Elem
5 Joe $5,667.88 Stevens Elem
6 Jill $3,546.77 Ball Elem
7 Josh $7,584.89 Grove Elem
8 Joe $1,243.55 Grandview Elem
9 Jill $7,896.22 Valley Elem
ECT............
I would like to see on the spreadsheet the total cumulative sales for each rep as the data is entered into the spreadsheet. I imagine this is possible, but I have no clue how to do this.
Thank you for your help!!
Ron D.
Bookmarks