Will 7 IFs remain ?

[Guest]

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 ?

 

[Don Guillett]

A more detailed explanation might help

 

[Guest]

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?

 

[Guest]

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?

 

[Biff]

I can't wait to see the Excel 2007 version of 64 nested IF's!

Biff

 

[Guest]

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 ?

 

[Guest]

What are you talking about?

 

[Guest]

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 ?

 

[Guest]

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]

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.

 

[Guest]

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.

 

[Biff]

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

 

[Guest]

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?