geomean ignoring blank cells and chars

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!
 
H

hrlngrv

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

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

Excel - Geomean - Ignoring Empty Cells 13
Geomean function 10
Geomean range 5
geomean 20
Excel Concatenate with line breaks but ignore blank cells 3
COUNT rows on external sheet if between date range 3
Array Formulas for Geometric Standard Deviation and Sharpe 6
Sum Of Last Two Entries in Rotating Columns 6

Top