Hi everybody. I'm relatively new to formulas that seem this complex. I am usually just going to try new things until I figure it out. I am a business manager and I'm trying to build a spreadsheet that I can show all of my salespeople what they are doing per product so we can figure out what each one of them need to work on each month. I am building off a spreadsheet that I have fine tuned over the last 3 years but this is a whole new ball game. Previously, this sheet just broke down the total amount of everything and how many sales each person had each month, basically a simple formula that just searched Column P to see how many times each sales persons name is listed that they didn't see. It was just for me to be able to send money owed to each vendor each month. The grayed out box is the only addition, which I feel like is an easier fix than I'm making it out to be.
Bookmarks