=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