L
lamontd7
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 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 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 row. Can anyone tell me how to do that?
Thank you for any help you can give me.
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 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 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 row. Can anyone tell me how to do that?
Thank you for any help you can give me.