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.



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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=470083