Home |
Search |
Today's Posts |
|
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 ? |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Online worksheet and remain sortable? | Excel Discussion (Misc queries) | |||
Can a copy of a chart remain "live" | Charts and Charting in Excel | |||
How do I get word wrap format to remain in an Excel pivot table? | Excel Discussion (Misc queries) | |||
remain constant in a copy & paste | New Users to Excel | |||
NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW?? | Excel Discussion (Misc queries) |