Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Average formula | Excel Discussion (Misc queries) | |||
Formula to average certain times | Excel Discussion (Misc queries) | |||
Average Formula | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |