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 ?