Array Formula

  • Thread starter Thread starter forevergrateful
  • Start date Start date
F

forevergrateful

I'm trying to geomean the values of certain rows based on whether they are
within a particular date range. Here is the formula I've put together:

=GEOMEAN(IF(($A$37:$A$966>=$AW21)*($A$37:$A$966<=$AX21),BD$37:BD$966)^12-1)

$A$37:$A$966 -- The date range
$AW21 -- The begin date
$AX21 -- The end date
BD$37:BD$966 -- The values
)^12-1 -- annualizing the monthly values

Any help would be greatly appreciated.

FG
 
Update:

Got this to work by separating the two parts:

=GEOMEAN(IF(($A$37:$A$966>=$AW21)*($A$37:$A$966<=$AX21),BD$37:BD$966)

Then I looked to this value and did the normalization: i.e., ^12-1

Why won't it work with the full formula together?

Thanks for the kind responses!

FG
 
Back
Top