+ Reply to Thread
Results 1 to 3 of 3

Statistics (average of multiple divisions)

  1. #1
    markx
    Guest

    Statistics (average of multiple divisions)

    Hello everybody,

    I try to figure out a "one-cell" formula that could make a following
    calculation:

    From B6 to AZ6 I have one range of numbers
    From B7 to AZ7 I have another range (numbers as well)

    What interests me is to find an average of B6/B7, C6/C7, D6/D7 until
    AZ6/AZ7.
    For sure, I can make a long formula that makes 1000 miles to write:-), but
    I'm sure there is an easier way...

    Thanks a lot for your help on this!

    Mark



  2. #2
    Bob Phillips
    Guest

    Re: Statistics (average of multiple divisions)

    Hi Mark,

    If all of the divisor cells have a value then

    =AVERAGE(B6:AZ6/B7:AZ7)

    If some are empty, or you are not sure then

    =AVERAGE(IF(B7:AZ7<>0,B6:AZ6/B7:AZ7))

    Both are array formulas, so commit with Ctrl-Shift-Enter.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "markx" <markx@discussions.microsoft.com> wrote in message
    news:OCP4HhgLFHA.568@TK2MSFTNGP09.phx.gbl...
    > Hello everybody,
    >
    > I try to figure out a "one-cell" formula that could make a following
    > calculation:
    >
    > From B6 to AZ6 I have one range of numbers
    > From B7 to AZ7 I have another range (numbers as well)
    >
    > What interests me is to find an average of B6/B7, C6/C7, D6/D7 until
    > AZ6/AZ7.
    > For sure, I can make a long formula that makes 1000 miles to write:-), but
    > I'm sure there is an easier way...
    >
    > Thanks a lot for your help on this!
    >
    > Mark
    >
    >




  3. #3
    markx
    Guest

    Thanks!

    Thanks Bob,

    Worked perfectly for me!
    Thanks as well for underlining ARRAY thing, without this I would surely get
    wrong results..

    Cheers,
    Mark

    "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
    news:OT5I93gLFHA.1948@TK2MSFTNGP14.phx.gbl...
    > Hi Mark,
    >
    > If all of the divisor cells have a value then
    >
    > =AVERAGE(B6:AZ6/B7:AZ7)
    >
    > If some are empty, or you are not sure then
    >
    > =AVERAGE(IF(B7:AZ7<>0,B6:AZ6/B7:AZ7))
    >
    > Both are array formulas, so commit with Ctrl-Shift-Enter.
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "markx" <markx@discussions.microsoft.com> wrote in message
    > news:OCP4HhgLFHA.568@TK2MSFTNGP09.phx.gbl...
    > > Hello everybody,
    > >
    > > I try to figure out a "one-cell" formula that could make a following
    > > calculation:
    > >
    > > From B6 to AZ6 I have one range of numbers
    > > From B7 to AZ7 I have another range (numbers as well)
    > >
    > > What interests me is to find an average of B6/B7, C6/C7, D6/D7 until
    > > AZ6/AZ7.
    > > For sure, I can make a long formula that makes 1000 miles to write:-),

    but
    > > I'm sure there is an easier way...
    > >
    > > Thanks a lot for your help on this!
    > >
    > > Mark
    > >
    > >

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1