Suppose I have column A with four numbers 1 3 4 2 and B with the result of each step
Thus B would display 1 4 8 10
I want to use a formula that adds up A, using only column A as input to column B
Thus column B would automatically be calculated as:
1 = 1
4 = 1+3
8 = 1+3+4
10 = 1+3+4+2
MacBook Air 15″, macOS 15.2
One way to do this is to use an "expanding range", like this:
=SUM(A$1:A1)
The $ is an anchor. When you drag down the range within the SUM function expands.
SG
One way to do this is to use an "expanding range", like this:
=SUM(A$1:A1)
The $ is an anchor. When you drag down the range within the SUM function expands.
SG
Bomiboll wrote:
Is there a support guide ?
For functions, go in your menu to Help > Formulas and Functions Help
For general use of Numbers, see User Guide at Help > Numbers Help.
Note that most Numbers functions work the same as the equivalent Excel functions so you can also do an internet search. For example, for expanding ranges (more accurately expanding references) you can do a search for that and turn up results like this:
https://spreadsheetweb.com/expanding-references-in-excel/
SG
In B1 put =A1
In B2 put =B1+A2-A1
Then drag down
Dubbia uses B column which I said I want to exclude.
SGII solution works as I want.
Is there a support guide ?
Bomiboll wrote:
Dubbia uses B column which I said I want to exclude.
SGII solution works as I want.
Is there a support guide ?
Numbers User Guide for Mac - Apple Support
How to add a column step by step
