Re: Will 7 IFs remain ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <driller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BE563AF2-FBDA-4CA1-B1C4-2DB6B8D9DD17@xxxxxxxxxxxxxxxx
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
dguillett1@xxxxxxxxxxxxx
"driller" <driller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:050618F5-6B7B-4B59-9B53-5C9FF3DBE693@xxxxxxxxxxxxxxxx
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
dguillett1@xxxxxxxxxxxxx
"driller" <driller@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:91035BCE-C180-4017-8C3B-EE557FEFF67B@xxxxxxxxxxxxxxxx
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 ?









.

Relevant Pages

  • Re: Will 7 IFs remain ?
    ... Sumproduct already works on implied IF logic: ... excel standard function that i can pull down from fx button ... "Don Guillett" wrote: ... maybe u can help us reach MS excel to introduce a function called ...
    (microsoft.public.excel.worksheet.functions)
  • Re: update/append query
    ... controlling space there is the possibility of the data ... integrity being broken. ... try to re-import the data to the database you'll get an error. ... Foreign Key to another table - Excel won't be able to enforce data ...
    (microsoft.public.access.queries)
  • Re: Is Chris Hills a troll?
    ... protecting the integrity of the central object - that ... other similar religious organizations) is that the fanatics drive the ... To state that the standard is not useful and should be changed is ...
    (comp.lang.c)
  • Re: PCB Design
    ... >integrity between the 'cap'-less version and the fully featured one. ... >probes), especially because I think the standard close grounding pin is ...
    (sci.electronics.design)
  • Re: File Size
    ... "Jan Karel Pieterse" wrote: ... integrity or crashing? ... Sharing Excel files is a dangerous thing to do as Excel ...
    (microsoft.public.excel.misc)