Em Andamento

Excel formula using nested IF statements

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.

Habilidades: Excel

Ver mais: statements excel, excel statements, cust write, excel spreadsheet formula, need a salesperson, how to look for a salesperson, excel expert 2013, statements, sales dashboard, i need a salesperson, excel formula, excel formula spreadsheet spreadsheet, data set formula, excel pdf formula, excel 2013 formula, excel unique, spreadsheet expert excel large, excel additional, nested, excel 2013 expert, need formula, dashboard excel using, excel dashboard using, pdf expert excel pdf, excel expert pdf

Acerca do Empregador:
( 36 comentários ) West Linn, Canada

ID do Projeto: #5087743

Premiar a:

farr4u

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.

$23 USD em 1 dia
(13 Avaliações)
3.4

2 freelancers estão ofertando em média $27 para este trabalho

pachu11

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.

$30 USD in 3 dias
(4 Comentários)
1.4