display a number in another cell

M

Motherlulu

Hello,

I would like the number that is displayed in row M15:L15 to display in row
M15. Only one cell would have a number in it.

Thanks for your help
 
D

Don Guillett

Unless you just want to clear the other column, A bit of clarification is
needed.
 
T

Toppers

.. i don't uderstand what you want: you cannot put a formula in M15 which
references M15.

Do you mean M15:L15 or A15:L15?

=MAX(A15:L15) would work if there is only one cell with a number.
 
D

David Biddulph

M15 can't be both the output cell of your formula and one of your input
cells.
If your input is in only one cell of the range A15:L15, then you can put
=SUM(A15:L15) into M15.
 
Top