Trevor (and Niek and William),

Thanks for the come back.

I do have the letter N in cell K3, letter O in cell K4, and letter M in cell
K5.
These letters will change with time, so that is why I assigned number values
to them. The running total for each row and column will have a consistant
value.

So, I need to display N,O,M in the cells but need a number at the end
representing a total.

I tried your suggestions:

=INDIRECT(K3) gives a #REF! error
same for
=INDIRECT(K3)+INDIRECT(K4)+INDIRECT(K5)
and for
=sum(INDIRECT(K3)+INDIRECT(K4)+INDIRECT(K5))
and
=sum(INDIRECT(K3),INDIRECT(K4),INDIRECT(K5))


Any other suggestions?

"Trevor Shuttleworth" wrote:

If that's how you've defined the names you would use:

=N+O+M = 100

=INDIRECT(K3) would show 20 if K3 had N in it

=INDIRECT(K3)+INDIRECT(K4)+INDIRECT(K5) = 100

Regards

Trevor


"AKPhil" wrote in message
...
Excel 2003

Menu: Insert = Name = Define:

N = 20
O = 30
M = 50

Let's say cell(s):

K3 has N displayed
K4 has O displayed
K5 has M displayed

=SUM(K3:K5) displays 0

How do I make it display the number 100? As in 20+30+50=100