Re: Applying a formula to a column

From: Dana DeLouis (delouis_at_bellsouth.net)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 07:03:06 -0500

Here are two similar ideas. This is an array formula...(Ctrl-Shift-Enter)

  =SUM(A1:A4-3)/2

and this is a non-array entered formula...
  =SUMPRODUCT(A1:A4-3)/2

HTH 

-- 
Dana DeLouis
Win XP & Office 2003
"Andrew Clark" <lark047@hotmail.com> wrote in message 
news:1106801755.b4a0a0a6ed01ec090c79fe96f263e267@teranews...
> Hello,
>
> Say I have a column that I want to work on with a formula. I want to take
> each value from the column, apply the formula to it, and total the result
> in a footer cell for the column. Example: subtract 3 and multiply by 1/2
>
> 1
> 2
> 3
> 4
>
> will produce -1 + -1/2 + 0 + 1/2 = -1. I would like to do this without a
> hidden column to hold the intermediate results of applying the function
> to each cell - so this is NOT what I want:
>
> 1      -1
> 2    -0.5
> 3       0
> 4     0.5
>
> and sum the intermediate column to find the answer. Is there a way to do
> this? I'm using Excel 2002
>
> Thanks,
> Andrew
Loading