geomean ignoring blank cells and chars

  • Thread starter Thread starter Stan Altshuller
  • Start date Start date
S

Stan Altshuller

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
Click to expand...

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).
 
Back
Top