View Single Post
  #1   Report Post  
Steve Almond
 
Posts: n/a
Default 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