Excel formula using nested IF statements
$10-30 USD
Paid on delivery
I need a MS Excel expert to write a nested IF or SUMIFS formula to build a dashboard from a large data set of sales tracings. See attached pdf and spreadsheet. I have sales data that i wish to isolate how many unique customers drive the orders. I currently have the formula o calculate this desired number for the entire column but I need to add an additional criteria (Salesperson ID) and calculate the number of unique "Cust ID's" associated with each Salesperson ID.
Take a look and let me know.
Project ID: #5087743
About the project
Awarded to:
Hi, excel expert here, Ready to stary,, I will give you a quice solution, want to send you a DEMO app in excel to give you an idea of the functionality I can offer.
2 freelancers are bidding on average $27 for this job
I can do the job. I have lot of experience in converting PDF, excel and photoshop. Please read the comments on my previous work. I can start right now.