Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default 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 ?






  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default 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 ?








  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default 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 ?









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Online worksheet and remain sortable? guyfromage Excel Discussion (Misc queries) 2 October 13th 06 01:04 PM
Can a copy of a chart remain "live" SouthAfricanStan Charts and Charting in Excel 1 October 13th 06 03:11 AM
How do I get word wrap format to remain in an Excel pivot table? KSchmidt Excel Discussion (Misc queries) 3 October 12th 06 10:39 PM
remain constant in a copy & paste Viviank New Users to Excel 5 March 18th 06 10:33 PM
NEED A PART OF THE TABLE TO REMAIN IN THE SCREEN, HOW?? san Excel Discussion (Misc queries) 2 September 2nd 05 05:47 PM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"