CODEWITHSUNDEEP
excel
jlo
jlo

Reputation: 2269

Associate a letter with a cell (Excel 2010)

I have a spreadsheet with different elements, let's say something along these lines (table from A1 to C2):

A  B  C
13 56 120

Is there a way how I can write in another cell "=A+B+C" and get the result of 13+56+120=189? Thanks!

Upvotes: 0

Views: 52

Answers (1)

Gary's Student
Gary's Student

Reputation: 96771

You can assign a Name to a cell and then use that Name in other formulas.

Click on A1

Then click in the Name Box and enter:

A + Enter

This give the cell A1 the Name A

Elsewhere you can enter formulas like:

=A + 15

Upvotes: 1

Related Questions