Results 1 to 3 of 3

Working out the geomeans of varying lengths in the same column

Threaded View

  1. #1
    Registered User
    Join Date
    09-16-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    24

    Working out the geomeans of varying lengths in the same column

    Hey,
    I'm trying to make a spread sheet that calculates the relevant 3M LIBOR rates for a bunch of possible investments. To do this I have to take a geomean of 3M LIBOR rates all the months for which I have return data on the investments. I have the relative row number for the beginning and end of the period I want the geomean of but I can't figure out how to write a formula.

    so I have a column of rates and two cells displaying the rows I want:
    ___________ cell B2= 2, cell B3= 6
    1.2
    1.4
    4.2
    2.3
    6.4
    0.9
    0.5

    and I would like to work out the geomean of the number between (and including) rows 2 and 6. I tried to use:

    =GEOMEAN(INDEX(A1:A7,B2,1):INDEX(A1:A7,B2,1))

    But no avail.

    Thanks


    EDIT: I figured it out...
    Last edited by Adamcadaver; 09-20-2010 at 05:54 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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