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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GEOMEAN 14
Matching data 3
Excel - Geomean - Ignoring Empty Cells 13
Geomean function 10
Cell reference in formula 1
GEOMEAN Function 8
Problem with GEOMEAN - returns #NUM error 6
Geomean in an Array Formula 2

Back
Top