Ask Your Question
0

Need formula with Dynamic RANGE [closed]

asked 2014-01-28 18:25:55 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I want to sum a column of numbers ONLY down to the current (not the last) row. something like

B{THISROW} = SUM(A1:A{THISROW}).

THUS, IF COLUMN A HAS {10,3,2,5,8,12), THE CONDITIONAL SUM (IN COLUMN B) WOULD BE(10,13,15,20,28,40)

edit retag flag offensive reopen merge delete

Closed for the following reason not a real question by Alex Kemp
close date 2016-02-19 03:59:29.230756

1 Answer

Sort by » oldest newest most voted
0

answered 2014-01-28 19:40:19 +0100

Regina gravatar image

If data are in cells A1:A9, write in cell B1 the formula =sum($A$1:A1) and copy fill it down. The $ sign prevents, that the start cell of the range is adapted. Look for "absolute" and "relative" address in the Calc guides.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-01-28 18:25:55 +0100

Seen: 1,323 times

Last updated: Jan 28 '14