List Info

Thread: Large Formula condensed with Sumproduct
Large Formula condensed with Sumproduct
user name
 2006-09-07 13:41:09 
Probably you have not made this formula before, but the
inspiration to make
this formula is from you..!

Regds; Rajeev Nair

On 9/7/06, Umlas, Robert <rumlaskpmg.com> wrote:
>
> I don't remember doing something like this, but I'll
have a wild turkey
> (even tho I don't drink!)
>
>
>
> *** ANY TAX ADVICE IN THIS COMMUNICATION IS NOT
INTENDED OR WRITTEN BY
> KPMG TO BE USED, AND CANNOT BE USED, BY A CLIENT OR ANY
OTHER PERSON OR
> ENTITY FOR THE PURPOSE OF (i) AVOIDING PENALTIES THAT
MAY BE IMPOSED ON ANY
> TAXPAYER OR (ii) PROMOTING, MARKETING OR RECOMMENDING
TO ANOTHER PARTY ANY
> MATTERS ADDRESSED HEREIN. ***
> Any advice in this communication is limited to the
conclusions
> specifically set forth herein and is based on the
completeness and accuracy
> of the stated facts, assumptions and/or representations
included. In
> rendering our advice, we may consider tax authorities
that are subject to
> change, retroactively and/or prospectively, and any
such changes could
> affect the validity of our advice. We will not update
our advice for
> subsequent changes or modifications to the law and
regulations, or to the
> judicial and administrative interpretations thereof.
> The advice or other information in this document was
prepared for the sole
> benefit of KPMG's client and may not be relied upon by
any other person or
> organization. KPMG accepts no responsibility or
liability in respect of this
> document to any person or organization other than
KPMG's client.
>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
>
>
>
>
> From: MS Excel General Q & A List
[mailto:EXCEL-GPEACH.EASE.LSOFT.COM]
> On Behalf Of Rajeev Nair
> Sent: Thursday, September 07, 2006 8:15 AM
> To: EXCEL-GPEACH.EASE.LSOFT.COM
> Subject: Re: Large Formula condensed with Sumproduct
>
> Inspired from Bob Umlas 
> Will share the "wild turkey" with him in
the Excel Users' Conference...
> When will in Asia / Middle/East..??!!
>
> Regds; Rajeev Nair
>
>
> On 9/7/06, Don Guillett <dguillett1austin.rr.com> wrote:
> >
> > Thanks so much. Exactly what was needed. I owe you
a "wild turkey"
> >
> > Don Guillett
> > SalesAid Software
> > dguillett1austin.rr.com
> > ----- Original Message -----
> > From: "Rajeev Nair"
<rajeevknair77GMAIL.COM>
> > To: < EXCEL-GPEACH.EASE.LSOFT.COM>
> > Sent: Thursday, September 07, 2006 5:41 AM
> > Subject: Re: Large Formula condensed with
Sumproduct
> >
> >
> > > Don,
> > >
> > > ARRAY ENTER;
> > >
> >
>
=SUMPRODUCT(((B734:AH734)-(B733:AH733))/(B733:AH733)*TRANSPO
SE(CD4:CD36)
> )
> > >
> > > B Regds; Rajeev Nair
> > >
> > >
> > > On 9/7/06, Don Guillett <dguillett1austin.rr.com > wrote:
> > >>
> > >> I must be getting old cuz I can't
remember the short way to do this
> for
> > >> my
> > >> client. Problem with cd4:cd5?
> > >> short version
> > >>
=(($B734-$B733)/$B733)*CD$4+(($C734-$C733)/$C733)*CD$5
> > >>
> > >> actual formula
> > >>
> > >>
> >
>
=(($B734-$B733)/$B733)*CD$4+(($C734-$C733)/$C733)*CD$5+(($D7
34-$D733)/$D
>
733)*CD$6+(($E734-$E733)/$E733)*CD$7+(($F734-$F733)/$F733)*C
D$8+(($G734-
>
$G733)/$G733)*CD$9+(($H734-$H733)/$H733)*CD$10+(($I734-$I733
)/$I733)*CD$
>
11+(($J734-$J733)/$J733)*CD$12+(($K734-$K733)/$K733)*CD$13+(
($L734-$L733
> )/$L733)*CD$14+(($M734-$M733)/$M733)*CD$15
> >
> > >>
> > >>
> >
>
+(($N734-$N733)/$N733)*CD$16+(($O734-$O733)/$O733)*CD$17+(($
P734-$P733)/
>
$P733)*CD$18+(($Q734-$Q733)/$Q733)*CD$19+(($R734-$R733)/$R73
3)*CD$20+(($
>
S734-$S733)/$S733)*CD$21+(($T734-$T733)/$T733)*CD$22+(($U734
-$U733)/$U73
>
3)*CD$23+(($V734-$V733)/$V733)*CD$24+(($W734-$W733)/$W733)*C
D$25+(($X734
>
-$X733)/$X733)*CD$26+(($Y734-$Y733)/$Y733)*CD$27+(($Z734-$Z7
33)/$Z733)*C
>
D$28+(($AA734-$AA733)/$AA733)*CD$29+(($AB734-$AB733)/$AB733)
*CD$30+(($AC
>
734-$AC733)/$AC733)*CD$31+(($AD734-$AD733)/$AD733)*CD$32+(($
AE734-$AE733
>
)/$AE733)*CD$33+(($AF734-$AF733)/$AF733)*CD$34+(($AG734-$AG7
33)/$AG733)*
> CD$35+(($AH734-$AH733)/$AH733)*CD$36
> >
> > >>
> > >> Don Guillett
> > >> SalesAid Software
> > >> dguillett1austin.rr.com
> > >>
> > >>
> >
>
------------------------------------------------------------
------------
> --
> > >> The EXCEL-G list is hosted on a Windows
NT(TM) machine running
> L-Soft
> > >> international's LISTSERV(R) software. 
For subscription/signoff
> info
> > >> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html
> .
> > >>                             COPYRIGHT
INFO:
> > >>
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> > >>
> > >
> > >
> >
>
------------------------------------------------------------
------------
> --
> > > The EXCEL-G list is hosted on a Windows
NT(TM) machine running
> L-Soft
> > > international's LISTSERV(R) software.  For
subscription/signoff info
> > > and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html
> .
> > >                             COPYRIGHT INFO:
> > >
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> > >
> > >
> > > --
> > > No virus found in this incoming message.
> > > Checked by AVG Free Edition.
> > > Version: 7.1.405 / Virus Database:
268.12.0/439 - Release Date:
> 9/6/2006
> > >
> > >
> >
> >
>
------------------------------------------------------------
------------
> --
> > The EXCEL-G list is hosted on a Windows NT(TM)
machine running L-Soft
> > international's LISTSERV(R) software.  For
subscription/signoff info
> > and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> >                             COPYRIGHT INFO:
> > http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
> >
>
>
------------------------------------------------------------
------------
> --
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
>
>
>
>
************************************************************
*****************
> The information in this email is confidential and may
be legally
> privileged.  It is intended solely for the addressee.
Access to this email
> by anyone else is unauthorized.
>
> If you are not the intended recipient, any disclosure,
copying,
> distribution or any action taken or omitted to be taken
in reliance on it,
> is prohibited and may be unlawful. When addressed to
our clients any
> opinions or advice contained in this email are subject
to the terms and
> conditions expressed in the governing KPMG client
engagement letter.
>
>
************************************************************
*****************
>
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software.  For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>                             COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>

------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software.  For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )