fill columns by introduction of data
 

variables (accounts): 14000; 14100; 14200; 14410; 14480
for each one fo them there are 3 hypothesis: Contracts (C), contracts with
external trainers (NH) and Invoices (F)
for each account there are different budgets for Contracts, Contracts with
External Trainers and Invoices.
which formula to use so that when I say that the account is 14000 and it is
a Contrat the right value (budget-x) should be inscribed
ty for all the help

fill columns by introduction of data
 

=sumproduct(--(account range = 14000),--(contract type range = C),--(budget
range))

"tmonte" wrote:

variables (accounts): 14000; 14100; 14200; 14410; 14480
for each one fo them there are 3 hypothesis: Contracts (C), contracts with
external trainers (NH) and Invoices (F)
for each account there are different budgets for Contracts, Contracts with
External Trainers and Invoices.
which formula to use so that when I say that the account is 14000 and it is
a Contrat the right value (budget-x) should be inscribed
ty for all the help

fill columns by introduction of data
 

I thank you but it did not helped
I was thought that maybe if D5=14000 and E5=C then U5=value specifying that
D5 can be 14000, 14100, 14200, 14410 or 14480 and E5=C, NH or F
range of 14000 = (U:W), 14100=(X:Z) and so on

"Sean Timmons" escreveu:

=sumproduct(--(account range = 14000),--(contract type range = C),--(budget
range))

"tmonte" wrote:

variables (accounts): 14000; 14100; 14200; 14410; 14480
for each one fo them there are 3 hypothesis: Contracts (C), contracts with
external trainers (NH) and Invoices (F)
for each account there are different budgets for Contracts, Contracts with
External Trainers and Invoices.
which formula to use so that when I say that the account is 14000 and it is
a Contrat the right value (budget-x) should be inscribed
ty for all the help