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(B3-C3) and wish this formula to be repeated down the column, so B4-C4 etc, without actually h

Hi Pat,

"=SUM(B3-C3)" works. Another option is "=B3-C3" 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

Pat,

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

Hi Pat,

Jerry's idea is great I'll make a mental note of that, didn't know it could be done!

Regards

Cliff