|
Will 7 IFs remain ?
I donot know yet until now if it is possible to have an excel standard 7 IFs
formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
Why don't you think it would work?
1) seven ifs work 2) sumproduct works so why shouldn't they work together? question is, can you make them work together? -- Allllen "driller" wrote: I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
thanks for reply with a hard question...I thought you can help me solve this
question ? It look like "sumproduct" is a longer word than IF"...anyway... in common english simple term = sumproduct is the sum of product. Maybe its better to put a standard excel suffix, hear like sumproductif - same with the rest countif, sumif...to avoid the common denominators perception of a very poor english formula name will provide a correct result. Ain't it? "Allllen" wrote: Why don't you think it would work? 1) seven ifs work 2) sumproduct works so why shouldn't they work together? question is, can you make them work together? -- Allllen "driller" wrote: I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
I can't wait to see the Excel 2007 version of 64 nested IF's!
Biff "Don Guillett" wrote in message ... A more detailed explanation might help -- Don Guillett SalesAid Software "driller" wrote in message ... I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
ooops. almost forgot, How many logical criteria's available on sumproduct ?
I cant see it in excel 2003 help, i just see arrays I cant find any logical_test criterias. Can we see this in next upgrade ? "Allllen" wrote: Why don't you think it would work? 1) seven ifs work 2) sumproduct works so why shouldn't they work together? question is, can you make them work together? -- Allllen "driller" wrote: I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
What are you talking about?
-- Brevity is the soul of wit. "driller" wrote: thanks for reply with a hard question...I thought you can help me solve this question ? It look like "sumproduct" is a longer word than IF"...anyway... in common english simple term = sumproduct is the sum of product. Maybe its better to put a standard excel suffix, hear like sumproductif - same with the rest countif, sumif...to avoid the common denominators perception of a very poor english formula name will provide a correct result. Ain't it? "Allllen" wrote: Why don't you think it would work? 1) seven ifs work 2) sumproduct works so why shouldn't they work together? question is, can you make them work together? -- Allllen "driller" wrote: I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
its english Dave, I click Fx button, choose sumproduct function, pop-up form
appears for sumproduct "tarannnn " you can see the form box instruction - excel standard way -arrays-. out of that, how to assure ? "Dave F" wrote: What are you talking about? -- Brevity is the soul of wit. "driller" wrote: thanks for reply with a hard question...I thought you can help me solve this question ? It look like "sumproduct" is a longer word than IF"...anyway... in common english simple term = sumproduct is the sum of product. Maybe its better to put a standard excel suffix, hear like sumproductif - same with the rest countif, sumif...to avoid the common denominators perception of a very poor english formula name will provide a correct result. Ain't it? "Allllen" wrote: Why don't you think it would work? 1) seven ifs work 2) sumproduct works so why shouldn't they work together? question is, can you make them work together? -- Allllen "driller" wrote: I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
Hi Don,
maybe u can help us reach MS excel to introduce a function called SUMPRODUCTIF...at least to assure that we can have an Fx formbox over excel standard and backup by helpfiles..Do you agree? "Don Guillett" wrote: A more detailed explanation might help -- Don Guillett SalesAid Software "driller" wrote in message ... I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
how about the existing ARRAY formula =Sum(if adapted to your needs? You have been asked repeatedly to furnish complete details about what you are trying to do............................... There may be an easier way. -- Don Guillett SalesAid Software "driller" wrote in message ... Hi Don, maybe u can help us reach MS excel to introduce a function called SUMPRODUCTIF...at least to assure that we can have an Fx formbox over excel standard and backup by helpfiles..Do you agree? "Don Guillett" wrote: A more detailed explanation might help -- Don Guillett SalesAid Software "driller" wrote in message ... I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
thanks for reply Don,
excel standard function that i can pull down from fx button 1. SUM 2.SUMIF 3.COUNT 4.COUNTIF 5.SUMPRODUCT 6. could be Sumproductif - If you dont mind ? hope no problem with your work. "Don Guillett" wrote: how about the existing ARRAY formula =Sum(if adapted to your needs? You have been asked repeatedly to furnish complete details about what you are trying to do............................... There may be an easier way. -- Don Guillett SalesAid Software "driller" wrote in message ... Hi Don, maybe u can help us reach MS excel to introduce a function called SUMPRODUCTIF...at least to assure that we can have an Fx formbox over excel standard and backup by helpfiles..Do you agree? "Don Guillett" wrote: A more detailed explanation might help -- Don Guillett SalesAid Software "driller" wrote in message ... I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
6. could be Sumproductif
And what would Sumproductif do? Sumproduct already works on implied IF logic: =SUMPRODUCT(--(A1:A10="x"),--(B1:B10="y")) IF A1:A10 equals "x" AND IF B1:B10 = "y" SUM the instances where BOTH conditions are TRUE. Biff "driller" wrote in message ... thanks for reply Don, excel standard function that i can pull down from fx button 1. SUM 2.SUMIF 3.COUNT 4.COUNTIF 5.SUMPRODUCT 6. could be Sumproductif - If you dont mind ? hope no problem with your work. "Don Guillett" wrote: how about the existing ARRAY formula =Sum(if adapted to your needs? You have been asked repeatedly to furnish complete details about what you are trying to do............................... There may be an easier way. -- Don Guillett SalesAid Software "driller" wrote in message ... Hi Don, maybe u can help us reach MS excel to introduce a function called SUMPRODUCTIF...at least to assure that we can have an Fx formbox over excel standard and backup by helpfiles..Do you agree? "Don Guillett" wrote: A more detailed explanation might help -- Don Guillett SalesAid Software "driller" wrote in message ... I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
Will 7 IFs remain ?
What it can do? maybe more than we expect....with english language integrity.
Lets hope for LCD's approach be well considered. Maybe next upgrades will not be in question- help files, support files, a lot of historically established function integrity. we're not alone in microsoft kingdom. Ain't it? "Biff" wrote: 6. could be Sumproductif And what would Sumproductif do? Sumproduct already works on implied IF logic: =SUMPRODUCT(--(A1:A10="x"),--(B1:B10="y")) IF A1:A10 equals "x" AND IF B1:B10 = "y" SUM the instances where BOTH conditions are TRUE. Biff "driller" wrote in message ... thanks for reply Don, excel standard function that i can pull down from fx button 1. SUM 2.SUMIF 3.COUNT 4.COUNTIF 5.SUMPRODUCT 6. could be Sumproductif - If you dont mind ? hope no problem with your work. "Don Guillett" wrote: how about the existing ARRAY formula =Sum(if adapted to your needs? You have been asked repeatedly to furnish complete details about what you are trying to do............................... There may be an easier way. -- Don Guillett SalesAid Software "driller" wrote in message ... Hi Don, maybe u can help us reach MS excel to introduce a function called SUMPRODUCTIF...at least to assure that we can have an Fx formbox over excel standard and backup by helpfiles..Do you agree? "Don Guillett" wrote: A more detailed explanation might help -- Don Guillett SalesAid Software "driller" wrote in message ... I donot know yet until now if it is possible to have an excel standard 7 IFs formula in one cell wherein it will be merged with the proclaimed gem known as sumproduct. something like this... =if(a1=11, SUMPRODUCT(--(A1$J$2:$J$4),(A1-$J$2:$J$4), $L$2:$L$4, ),if(b11=12,sumprod...........,sumprod( (x:x)= "n",(y:y)="m",z:z))))))))) Does anyone from our mvps and medallist do this research, a question of 7 Ifs integrity ? |
| All times are GMT +1. The time now is 01:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com