Results 1 to 2 of 2

Thread: Excel - Workbook to Workbook Calculation

  1. Aug 12th, 2011, 10:38 AM #1
    7wgh
    7wgh is offline

    Thread Starter
    New Member
    Join Date
    Jul 2011
    Posts
    15

    Excel - Workbook to Workbook Calculation

    Hey, quick question here.

    In one workbook i have a range of values, for example A1:A20 of data entries where I need to calculate the average of those numbers and enter that average value in another workbook. I was wondering if its possible to complete this calculation across workbooks?
    Reply With Quote Reply With Quote
  2. Aug 12th, 2011, 11:18 AM #2
    kaliman79912
    kaliman79912 is offline
    PowerPoster kaliman79912's Avatar
    Join Date
    Jan 2009
    Location
    Ciudad Juarez, Chihuahua. Mexico
    Posts
    2,593

    Re: Excel - Workbook to Workbook Calculation

    Sure it is.

    Something like this:

    =AVERAGE([symbols.xlsx]Sheet1!$A$1:$A$20)

    where your source WorkBook is named "symbols.xlsx" your range is in Sheet "Sheet1"
    More important than the will to succeed, is the will to prepare for success.

    Please rate the posts, your comments are the fuel to keep helping people
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width