Words = Values

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

Thank You to Biff for the help before.

Now to go a step further, can you have the same state in
a different column represent a different number on the
same worksheet.

i.e. Column 1 Kansas = 16, Missouri = 14 (year 1999)
Column 2 Kansas = 12, Missouri = 22 (year 2000)

And still have them able to add up in each column.
 
Hi Jason,

Yes you can do that. That would be called a named range.

As an example: Insert>Name>Define
Name - Kansas
Refers To - A10,B14,C16,D25

To get the sum of those cells:

=SUM(KANSAS)

Will sum cells A10,B14,C16,D25

Biff
 
I thought I forgot something!
Refers To - =A10,B14,C16,D25
Biff

-----Original Message-----
Hi Jason,

Yes you can do that. That would be called a named range.

As an example: Insert>Name>Define
Name - Kansas
Refers To - A10,B14,C16,D25

To get the sum of those cells:

=SUM(KANSAS)

Will sum cells A10,B14,C16,D25

Biff

.
Click to expand...
 
Back
Top