Thread: Excel - Geomean - Ignoring Empty Cells
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
  
Posts: 690
Default Excel - Geomean - Ignoring Empty Cells
Oops. I Made a mistake. I left out the Ln() function, but it's still
not working. Let me think about this...

=Exp(Average(Ln( ??)))

=Exp(Average(If(A1:A40,A1:A4)))

- - -
Dana DeLouis
Reply With QuoteReply With Quote