Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing columns if there is data | Excel Worksheet Functions | |||
Auto fill Column based on data in other columns | New Users to Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |