Array functions

[Jim Baldwin]

Is there a way to sum the logs of the values in a column
using an array function? Using something like

=sum(ln(c2:c20))

doesn't work. I can place the logs in a scratch column but
I'm looking for a way to do it with only using an array
function. Any suggestions would be appreciated.

Thanks,

Jim

 

[Peo Sjoblom]

Enter it with ctrl + shift & enter and it will work

 

[Chip Pearson]

Jim,

Try

=LOG(PRODUCT(A1:A3))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)