Nested Functions
 

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

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

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