Range naming question

[JSH720]

Instead of:

N3*M3
N4*M4
N5*M5, ETC.

I have over 200 rows so far.

I want to be able to say:
Rate times quantity where N column is the rate and M column is the quantity for each row that I have. I add data (rows) each day.

How do I name the cells so that I can use a named cell in the formula for the current and new data rows in the spreadsheet?

Thanks.

 

[JSH720]

I forgot to say the real problem isn't when I copy to the next line, but when I copy across for 5 columns, the references change and I am having to manually change the reference formula. Thought a named range in the formula would prevent this.

Thanks.

 

[RoryA]

Which bit do you not want to change when you copy to the right?

 

[JSH720]

The rate in that particular row. Changes for each row.
Thanks.

 

[RoryA]

Then use:
=$N3*M3

the rows will both adjust when you copy down, but only the M column will adjust when copied to the right.

 

[JSH720]

Rate changes for each change in Row (say from row 4 to row 5), does not change for each column in that row.

ie

rate for c3, c4 c5, c6 c7 is the same as in c2
rate for d3 d4 d5 d6 d7 is the same as in d2, etc.

 

[JSH720]

just say your previous response. I'll try in a couple of minutes.

 

[JSH720]

Just incorporated the logic inyour response into my (very long) formula, and it worked perfectly.

Thank you again.