Creating an office spreadsheet with individual statistics

[Chinooka]

Hello everyone!

I am a rank amateur at excel and need a little help setting up a spreadsheet for my small office. What I am after is this; we are a 4 person finance office, we each sell finance products and are accountable for our profits and per sale average. I have set up a simple monthly spreadsheet which each person logs their individual sales and gross profit, which has a running total formula in one column. This all works great and at any time I can see what the office total is at whenever I want. What I would like if there was a seperate place on the worksheet that would record each employees number of deals and a running average profit per deal. They currently enter their initials inone of the columns so I think this is fairly easy, but not for a newb like me! Any help that could be offered would be awesome! Thanks

Bob

[K m]

Bob, do you have any sample data?

[Chinooka]

Here is a snippet of the sheet. The "BM" column is the individual manager initials.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Chinooka]

Managed to solve this with AVERAGEIF function.

Thanks for the warm welcome to the forum and goodbye

[FDibbins]

another satisfied customer lol