Your original suggestion works, if you enter it as an array formula. That
is, use CTRL+SHIFT+ENTER instead of just ENTER

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Steve Almond" wrote in message
...
I have a column of numbers. I want to sum the LOG of each number in the
column.
I thought =SUM(LOG(A1):LOG(A9)) or =SUM(LOG(A1:A9)) might work - but
they don't.

Of course =SUM(LOG(A1), LOG(A2), LOG(A3), ......LOG(A9)) does work, but
there must be an easier way?

Could someone tell me the answer?

Thanks,

Steve