Thread: geomean ignoring blank cells and chars
View Single Post
  #1   Report Post  
Stan Altshuller
 
Posts: n/a
Default 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!


Reply With QuoteReply With Quote