
Cliff Peters Jun 17, 2013 1:47 AM
Re: Hi, I am new to Numbers and am using iWork '09. How do I get the function formula (sum) to recognise when I am using the same formula in a column. eg, I have SUM(B3C3) and wish this formula to be repeated down the column, so B4C4 etc, without actually h in response to PatFrostHi Pat,
"=SUM(B3C3)" works. Another option is "=B3C3" No quotations.
The bottom Right corner of A3 has a o click & drag down page.
Alternatively click A3 then the position down the page you would like to end the formula, then got to Insert, Fill, Fill Down. NB I have set up a shortcut for it.
Enjoy
Hope this helps

Jerrold Green1 Jun 17, 2013 10:15 AM
Re: Hi, I am new to Numbers and am using iWork '09. How do I get the function formula (sum) to recognise when I am using the same formula in a column. eg, I have SUM(B3C3) and wish this formula to be repeated down the column, so B4C4 etc, without actually h in response to PatFrost SolvedPat,
Cliff's suggestion to eliminate the SUM function is not only an equivalent, it is the preferred way to express a simple difference. The SUM function serves only to confuse the reader since you only have one argument (expression) in your use of it, and SUM is only really useful with ranges or multiple arguments (expressions).
Your question is really about repeating a formula with relative addressing, not the use of SUM, be we can't resist commenting.
In addition to using the Fill tool, you can Copy the first cell and Paste it to the rest of the range. The result will be the same as a Fill. For small ranges, Fill works great. For very long ranges, like entire columns, sometimes there is a advantage to selecting an entire column by clicking on its tab and Pasting.
Jerry

PatFrost Jun 17, 2013 9:15 PM
Re: Hi, I am new to Numbers and am using iWork '09. How do I get the function formula (sum) to recognise when I am using the same formula in a column. eg, I have SUM(B3C3) and wish this formula to be repeated down the column, so B4C4 etc, without actually h in response to Cliff PetersThanks Cliff. I will give it a try when I get back into the accounts. Cheers.
Pat

PatFrost Jun 17, 2013 9:16 PM
Re: Hi, I am new to Numbers and am using iWork '09. How do I get the function formula (sum) to recognise when I am using the same formula in a column. eg, I have SUM(B3C3) and wish this formula to be repeated down the column, so B4C4 etc, without actually h in response to Jerrold Green1Thanks Jerry. I will try both ways. I am hoping this saves me a lot of work.
Pat

PatFrost Jun 17, 2013 9:25 PM
Re: Hi, I am new to Numbers and am using iWork '09. How do I get the function formula (sum) to recognise when I am using the same formula in a column. eg, I have SUM(B3C3) and wish this formula to be repeated down the column, so B4C4 etc, without actually h in response to Jerrold Green1Jerry, thank you!!!! I just did the copy and paste and it worked!!!! You have no idea how much time and effort you have saved me.
Pat

PatFrost Jun 17, 2013 9:27 PM
Re: Hi, I am new to Numbers and am using iWork '09. How do I get the function formula (sum) to recognise when I am using the same formula in a column. eg, I have SUM(B3C3) and wish this formula to be repeated down the column, so B4C4 etc, without actually h in response to Cliff PetersThanks again Cliff. It works! But as Jerry said, because I am doing whole accounts pages with multiple columns and rows, the copy and paste was quicker. Cheers. You two guys rock!
Pat

Cliff Peters Jun 18, 2013 2:02 AM
Re: Hi, I am new to Numbers and am using iWork '09. How do I get the function formula (sum) to recognise when I am using the same formula in a column. eg, I have SUM(B3C3) and wish this formula to be repeated down the column, so B4C4 etc, without actually h in response to PatFrostHi Pat,
Jerry's idea is great I'll make a mental note of that, didn't know it could be done!
Regards
Cliff