average in formula?
 

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: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521869

average in formula?
 

=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)

"fivermsg" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521869

average in formula?
 

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: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521869

average in formula?
 

Revise 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)

"Bob Phillips" wrote in message
...
=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)

"fivermsg" wrote
in
message ...

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:
http://www.excelforum.com/member.php...o&userid=32348
View this thread:
http://www.excelforum.com/showthread...hreadid=521869

average in formula?
 

=(((E5*1.05)/(E4*1.05))+((E6*0.89)/(E4*0.89))+((E7/E4)/(E4*60)))/COUNTIF(E5:E7,"0")

OR

=SUM((E5*1.05)/(E4*1.05)+(E6*0.89)/(E4*0.89)+(E7/E4)/(E4*60))/COUNTIF(E5:E7,"0")

"fivermsg" wrote:


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: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521869

average in formula?
 

"Bob Phillips" wrote in message
...
Revise that

=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 "*1.05", and similarly of
"*0.89"?
--
David Biddulph

average in formula?
 

No, that was my mistake, I revised it in a later post.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"fivermsg" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521869

average in formula?
 

Are you asking that, or just stating it?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"David Biddulph" wrote in message
...
"Bob Phillips" wrote in message
...
Revise that


=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 "*1.05", and similarly of
"*0.89"?
--
David Biddulph