Subtracting Values by Specific Row Number

**Balius** · 08-31-2009, 07:05 PM

Hi, I'm extremely new to Excel, and I have a simple question to ask.

I'm trying to make a formula that will take row specific values from two designated columns and subtract them, putting the result in a new column. I'm wondering how one would represent row number in a formula?
Here's what I mean: =J# - C#

Using =J(ROW()) - C(ROW()) didn't seem to work

thanks!

**shg** · 08-31-2009, 07:09 PM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

**Balius** · 08-31-2009, 07:23 PM

Title amended.

**shg** · 08-31-2009, 07:56 PM

Thanks.

Well, if you start in some arbitrary row, say K5, and enter the formula

=J5-C5

and then copy that to K6, the references will automatically adjust to

=J6-C6

That's a core thing that Excel does.

See Help for Switch between relative, absolute, and mixed references