Excel formula using nested IF statements

$10-30 USD

Completato

Pubblicato

più di 10 anni fa

$10-30 USD

Pagato al completamento

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.

Excel

Rif. progetto: 5087743

Info sul progetto

2 proposte

Progetto a distanza

Attivo 11 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato 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 in 1 giorno

4,9

(13 valutazioni)

3,4

2 freelance hanno fatto un'offerta media di $27 USD

@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 giorni