Formula for cumulative total

Is there a way to write a cumulative formula so when it is copied across a
row it sums the prior data in another row? For example:

Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05
100

Dave,

Assuming that row 1 is your headers, Oct-04, Nov-04 etc, and that row 2 is a quantity, 100, 120, etc
then in cell A3 put
=sum($a2:a2)
and formula-drag that across the row.

Originally Posted by Dave

Is there a way to write a cumulative formula so when it is copied across a
row it sums the prior data in another row? For example:

Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05
100

Hi,
Supposing that the column headers (i.e., months) are in Row 1 (starting at
Column A), and the data (e.g., 100 under Oct-04) are in Row 2, enter the
following formula in A3,
=SUM($A$2:A2)
and drag the formula across Row 3 to as many columns as you want. The
cumulative totals will show up in Row 3.

Regards,
B. R. Ramachandran

"Dave" wrote:

> Is there a way to write a cumulative formula so when it is copied across a
> row it sums the prior data in another row? For example:
>
> Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05
> 100

Could you be more specific about what is in addresses and data that you want to
sum and the address for the sum formula.-
---


"Dave" <Dave@discussions.microsoft.com> wrote in message news:2A276F4E-9C9F-429B-B1CB-DE4A0C758EEC@microsoft.com...
> Is there a way to write a cumulative formula so when it is copied across a
> row it sums the prior data in another row? For example:
>
> Oct-04 Nov-04 Dec-04 Jan-05 Feb-05 Mar-05 Apr-05
> 100