Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Numbers Help
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="CPM" data-source="post: 1230206" data-attributes="member: 200583"><p>Hi, this is my first time actually dealing with numbers and functions even though I've had my mac for awhile (1 year). I'm trying to create a running log for the summer, and the template just isn't what I want. I'm trying to create one column header with the day, and want to take the value of the cell above each cell in that column and add 1 to it, in order to get a running list of numbers (which would be the day) that column (eg: 1,2,3...). However, I can't figure out how to drag a certain formula (=Sum(A2+1)) down a column so that it applies to a whole column and so that the fourth row (A4) has the formula (=Sum(A3+1)) and the fifth row (A5) has the formula (=Sum(A4+1)) and so on. I've worked with excel, and there you just drag the first cell down when it has that first formula in it and it will automatically update it for each individual row. </p><p></p><p>Could anyone also help me with how to drag any formula to apply to all columns using the cells in their row of course, so that each row will have one cell with the time I ran, one with the distance, and one with the pace (it's basically the same question as above, but more general). </p><p></p><p>I know this is a little technical, but please ask me if I need to clarify something.</p><p></p><p>Thanks!</p></blockquote><p></p>
[QUOTE="CPM, post: 1230206, member: 200583"] Hi, this is my first time actually dealing with numbers and functions even though I've had my mac for awhile (1 year). I'm trying to create a running log for the summer, and the template just isn't what I want. I'm trying to create one column header with the day, and want to take the value of the cell above each cell in that column and add 1 to it, in order to get a running list of numbers (which would be the day) that column (eg: 1,2,3...). However, I can't figure out how to drag a certain formula (=Sum(A2+1)) down a column so that it applies to a whole column and so that the fourth row (A4) has the formula (=Sum(A3+1)) and the fifth row (A5) has the formula (=Sum(A4+1)) and so on. I've worked with excel, and there you just drag the first cell down when it has that first formula in it and it will automatically update it for each individual row. Could anyone also help me with how to drag any formula to apply to all columns using the cells in their row of course, so that each row will have one cell with the time I ran, one with the distance, and one with the pace (it's basically the same question as above, but more general). I know this is a little technical, but please ask me if I need to clarify something. Thanks! [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Numbers Help
Top