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!
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).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks