1. B

    GEOMEAN when I already know how many I have of each

    My first post here... please be gentle So I have a very, very large data set that I have distilled down to a table of 500 lines, summarized according to some COUNTIFS statements. Now what I need is the geometric mean of the totals. For example, in the first row I have pasted below, I know I...
  2. K

    GEOMEAN with IF(AND statement

    Hello I am having issues with getting a Geomean Array to work. I have a list of dates in column A and results in column B on one sheet. I am trying to code a formula to that looks a date 1 and date 2(cell E1 and E2) and Geomeans all the results with dates between date 1 and date 2. Here is what...
  3. V

    GEOMEAN IF for specific date range

    <tbody> date amt 1/1/02 2 1/1/03 6 1/1/05 4 1/1/10 7 1/1/11 1 1/1/13 2 1/1/15 5 1/1/17 7 </tbody> Hello, I was wondering if it is possible to utilize a geomean function based on a specific date selection? For example, the data that is located within 1/1/10 - 1/1/13. Any...
  4. L

    Geomean alternative for Averageifs

    Hi, I am trying to find the geometric mean of a range of values based on another range of data and if that falls into a certain bin width. So for example, finding the geometric mean of the values in column B, only if the values of column A fall within a certain bin width that I set at 1...
  5. D

    VBA for Geomean of Array within Array

    Hello, Would appreciate any help on a small issue. I have an array of arrays [ArrOfArr(1 to 7, 1 to 2)] where each element in the array is another array containing non-negative double type numbers [ie arr1(1 to x), arr2(1 to y)]. I am trying to find the geomean of each array within the array...
  6. C

    Calculating the Median, Mean, and GeoMean of dynamic range

    I have a spreadsheet with Data in Columns A-H. Column B is an ID value that will repeat an unknown amount of times. For each Value in Column B I need to calculate the Median, Mean, and GeoMean for the corresponding range of "G_:H_" Ex. <tbody> Column B Column G Column H 2 10...
  7. S

    Normalize returns

    Hi all, I have 2 times series of monthly stock returns. I want to normalize the 2nd series to the first, so the cumulative return of both end up in the same spot on a chart (to show the stdev of the 2nd compared to the first). Here is my current process that does not work: 1. Calc GEOMEAN of...

Some videos you may like

This Week's Hot Topics