Nested Functions

[Steve Almond]

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

 

[Niek Otten]

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

 

[JE McGimpsey]

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

See "About array formulas" in XL Help.