How to repeat a formula for each row?

Thank you very much Yvan.

That worked fine when I dragged the circle at the 'Total' cell.

I'm afraid that I could not find the information by searching through the 'Numbers Help File', and unfortunately I'm so unfamiliar with spreadsheets in general that even selecting the correct wording for my query is not always obvious to me. I've only now grasped that what I'm dragging into the adjacent cells in a column is, not the number in the first cell, but the formula that created the number.

I appreciate your help.

I have one further question though. I'm trying to sequentially number a column of cells 1,2,3,4 etc. in Numbers. In 'Pages' I know that I just number the first two as 1,2 and then drag the circle down the complete column of a table and it numbers the column of cells sequentially. But that does not work in 'Numbers'. Any idea how I might do that?

Thanks.

Message was edited by: esmonde

Thanks again Yvan.

I realised you were speaking about the 'guide', and I had not realised it was accessible when I did my initial search. I've since tried it for my second query and can't find the answer. I would not have found the first answer either because I do not fully grasp the concepts in spreadsheets yet.

While I really do appreciate your help and your pointers for sources of further information, I hope you will realise that sometimes being able to ask the correct question is critical when searching for information.

Regards.

Thanks Jerry.

I think that's good advice and I intend to follow it.

However, sometimes I'm up against the clock trying to solve a problem, and in desperation I reach out to these fora. And almost always I find helpful people like Yvan and yourself willing to contribute your expertise.

Consider me suitably chastened.

Regards

Thanks Jerry.