geomean ignoring blank cells and chars

[Stan Altshuller]

Hi!

How can I make geomean(1+D237) count ONLY the cells with numbers?

I am trying =GEOMEAN(1+IF(ISNUMBER(D237),D237))^12-1 using array
formula, its not working
Thanks!

 

[hrlngrv]

Stan Altshuller wrote...

How can I make geomean(1+D237) count ONLY the cells with numbers?

I am trying =GEOMEAN(1+IF(ISNUMBER(D237),D237))^12-1 using array
formula, its not working

You've misplaced the IF. Use

=GEOMEAN(IF(ISNUMBER(D237),1+D237))^12-1

And don't write 'its not working'. State exactly what happens (it
returns a wrong numeric result).