Your second example will work if you array-enter it (use
CTRL-SHIFT-ENTER or CMD-RETURN).

See "About array formulas" in XL Help.


In article ,
"Steve Almond" wrote:

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