software

how would i get the total of this equation
(((E5*1.05)/(E4*1.05)) ((E6*0.89)/(E4*0.89)) ((E7/E4)/(E4*60))) to
average?? meaning adding each inner equation and dividing by 3 won't
work cause sometimes these inner equations will =0 ... I want the
average of the inner equations omitting any zero values--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=521869=AVERAGE((E5*1.05)/(E4*1.05),(E6*0.89)/(E4*0.89),(E7/E4)/(E4*60))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;fivermsgquot; gt; wrote in
message ...
gt;
gt; how would i get the total of this equation
gt; (((E5*1.05)/(E4*1.05)) ((E6*0.89)/(E4*0.89)) ((E7/E4)/(E4*60))) to
gt; average?? meaning adding each inner equation and dividing by 3 won't
gt; work cause sometimes these inner equations will =0 ... I want the
gt; average of the inner equations omitting any zero values
gt;
gt;
gt; --
gt; fivermsg
gt; ------------------------------------------------------------------------
gt; fivermsg's Profile:
www.excelforum.com/member.php...oamp;userid=32348
gt; View this thread: www.excelforum.com/showthread...hreadid=521869
gt;

so what you are saying is that if one of those inner formulas =0 then it
would omit that one and just average the other two?--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
View this thread: www.excelforum.com/showthread...hreadid=521869Revise that

=SUM((E5*1.05)/(E4*1.05) (E6*0.89)/(E4*0.89) (E7/E4)/(E4*60))/COUNT(E5:E7)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Bob Phillipsquot; gt; wrote in message
...
gt; =AVERAGE((E5*1.05)/(E4*1.05),(E6*0.89)/(E4*0.89),(E7/E4)/(E4*60))
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;fivermsgquot; gt; wrote
in
gt; message ...
gt; gt;
gt; gt; how would i get the total of this equation
gt; gt; (((E5*1.05)/(E4*1.05)) ((E6*0.89)/(E4*0.89)) ((E7/E4)/(E4*60))) to
gt; gt; average?? meaning adding each inner equation and dividing by 3 won't
gt; gt; work cause sometimes these inner equations will =0 ... I want the
gt; gt; average of the inner equations omitting any zero values
gt; gt;
gt; gt;
gt; gt; --
gt; gt; fivermsg
gt; gt; ------------------------------------------------------------------------
gt; gt; fivermsg's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32348
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=521869
gt; gt;
gt;
gt;
=(((E5*1.05)/(E4*1.05)) ((E6*0.89)/(E4*0.89)) ((E7/E4)/(E4*60)))/COUNTIF(E5:E7,quot;gt;0quot;)

OR

=SUM((E5*1.05)/(E4*1.05) (E6*0.89)/(E4*0.89) (E7/E4)/(E4*60))/COUNTIF(E5:E7,quot;gt;0quot;)

quot;fivermsgquot; wrote:

gt;
gt; so what you are saying is that if one of those inner formulas =0 then it
gt; would omit that one and just average the other two?
gt;
gt;
gt; --
gt; fivermsg
gt; ------------------------------------------------------------------------
gt; fivermsg's Profile: www.excelforum.com/member.php...oamp;userid=32348
gt; View this thread: www.excelforum.com/showthread...hreadid=521869
gt;
gt;

quot;Bob Phillipsquot; gt; wrote in message
...
gt; Revise that
gt;
gt; =SUM((E5*1.05)/(E4*1.05) (E6*0.89)/(E4*0.89) (E7/E4)/(E4*60))/COUNT(E5:E7)

Presumably you could omit the two occurrences of quot;*1.05quot;, and similarly of
quot;*0.89quot;?
--
David Biddulph
No, that was my mistake, I revised it in a later post.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;fivermsgquot; gt; wrote in
message ...
gt;
gt; so what you are saying is that if one of those inner formulas =0 then it
gt; would omit that one and just average the other two?
gt;
gt;
gt; --
gt; fivermsg
gt; ------------------------------------------------------------------------
gt; fivermsg's Profile:
www.excelforum.com/member.php...oamp;userid=32348
gt; View this thread: www.excelforum.com/showthread...hreadid=521869
gt;
Are you asking that, or just stating it?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;David Biddulphquot; gt; wrote in message
...
gt; quot;Bob Phillipsquot; gt; wrote in message
gt; ...
gt; gt; Revise that
gt; gt;
gt; gt;
=SUM((E5*1.05)/(E4*1.05) (E6*0.89)/(E4*0.89) (E7/E4)/(E4*60))/COUNT(E5:E7)
gt;
gt; Presumably you could omit the two occurrences of quot;*1.05quot;, and similarly of
gt; quot;*0.89quot;?
gt; --
gt; David Biddulph
gt;
gt;