Hello, I am new to Excel and I need help with creating formulas. I am
trying to create a few formulas that will perform simple mathematical
operations on data contained in any given row of the spreadsheet. I
think I have figured out how to create a formula if I specify exactly
which cells I want to perform mathematical operations on (i.e.,
entering "=A2+B2" into cell C2), but what I really need is to create
universal formulas that, for any given row, will sum the values of
column A and column B of that same row (i.e, cell CX=AX+BX, where X
could be any single given row). For Row 5, for example, the formula
would be C5=A5+B5, but since entering a new formula into each cell one
by one wouldn't save me much/any time compared to just calculating the
sums manually, I am wondering if/how I can create a general formula
that will leave the row undefined and just perform mathematical
operations on two or more columns which I specify, for any given row in
the spreadsheet. In other words, I want to associate with column C a
formula that, for any given row, will sum the values in columns A and B
of that same given row. Can anyone tell me how to do that?

Thank you very much for any help you can give me.


--
lamontd7
------------------------------------------------------------------------
lamontd7's Profile: http://www.excelforum.com/member.php...o&userid=25760
View this thread: http://www.excelforum.com/showthread...hreadid=391710