geomean

  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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top