geomean ignoring blank cells and chars
 

Hi!

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

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

Stan Altshuller wrote...
How can I make geomean(1+D2:D37) count ONLY the cells with numbers?

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

You've misplaced the IF. Use

=GEOMEAN(IF(ISNUMBER(D2:D37),1+D2:D37))^12-1

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