GEOMEAN IF for specific date range

[vbaisdaxing]

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>
</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 thoughts or suggestions would be greatly appreciated.

thank you in advance.

 

[joeu2004]

Array-enter (press ctrl+shift+Enter instead of just Enter) a formula of the following form:

=GEOMEAN(IF(A2:A9 >= DATE(2010,1,1), IF(A2:A9 <= DATE(2013,1,1), B2:B9)))

 

[vbaisdaxing]

thank you joeu2004. Greatly appreciated. I thought i could figure it out with the how you set up the formula. but i was wondering how would you write the formula if you had a name column added. For example all entries with the name=A and the date range of 1/1/10 - 1/1/13 ? Thank you very much once again. I earlier tried
"=GEOMEAN(IF(AND(A2:A9 >= DATE(2010,1,1),B2:B9 = "A"), IF(AND(A2:A9 <= DATE(2013,1,1),B2:B9="A"), C2:C9)))"

date	name	amt
1/1/02	a	2
1/1/03	b	6
1/1/05	a	4
1/1/10	b	7
1/1/11	a	1
1/1/13	a	2
1/1/15	b	5
1/1/17	a	7

<tbody>
</tbody>

 

[joeu2004]

how would you write the formula if you had a name column added. [....] I earlier tried
=GEOMEAN(IF(AND(A2:A9 >= DATE(2010,1,1),B2:B9 = "A"), IF(AND(A2:A9 <= DATE(2013,1,1),B2:B9="A"), C2:C9)))

Array-enter (press ctrl+shift+Enter instead of just Enter) a formula of the following form:

=GEOMEAN(IF(B2:B9 = "A", IF(A2:A9 >= DATE(2010,1,1), IF(A2:A9 <= DATE(2013,1,1), C2:C9))))