View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default copying & averaging formulas

I'm pretty sure John, that XL will automatically put them in the correct
order for you.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JE McGimpsey" wrote in message
...
Note that 'Jan 07 Pace Final' sheet tab would need to be on the left and
the 'July 07 Pace' sheet tab on the right, with the listed sheet tabs in
between.

In article ,
JE McGimpsey wrote:

One way:

=SUM('Jan 07 Pace Final:July 07 Pace'!E7)/SUM('Jan 07 Pace
Final:July 07 Pace'!B7)