I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of an
*rather than creating the formula manually each time
--
George

First, use "=" instead of "@"
Next, EITHER replace the "+" inside the formula with ",", OR remove the SUM
function. It's doing double work.
Lastly, you can select the range in the formula, like the k4, and click on
another cell to change the reference.


"George A. Yorks" wrote:

I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of an
*rather than creating the formula manually each time
--
George

=ROUNDDOWN((((D4+F4+J4+O4+R4+S4)*3)-72)*0.8,0) This formula will add the six
cells etc. If I change the + to ",", the formula will not calculate. I can
click on a new cell and it will make the change but only in the first
position. Hope I have been clear enough with my explanation
--
George


"Bob Umlas, Excel MVP" wrote:

First, use "=" instead of "@"
Next, EITHER replace the "+" inside the formula with ",", OR remove the SUM
function. It's doing double work.
Lastly, you can select the range in the formula, like the k4, and click on
another cell to change the reference.


"George A. Yorks" wrote:

I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of an
*rather than creating the formula manually each time
--
George

George,

you need the + operators if your intention is to add those cells. If you
use a comma, ROUNDDOWN will think you're giving it more arguments, and will
choke.

SUM(D4+F4+J4+O4+R4+S4) will add them up, but the SUM function isn't
necessary since you're explicitly summing them with + operators.
SUM(D4, F4, J4, O4,R4, S4) will add them up, as SUM takes up to 31 (I think)
arguments

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"George A. Yorks" .(donotspam) wrote in message
...
=ROUNDDOWN((((D4+F4+J4+O4+R4+S4)*3)-72)*0.8,0) This formula will add the
six
cells etc. If I change the + to ",", the formula will not calculate. I
can
click on a new cell and it will make the change but only in the first
position. Hope I have been clear enough with my explanation
--
George


"Bob Umlas, Excel MVP" wrote:

First, use "=" instead of "@"
Next, EITHER replace the "+" inside the formula with ",", OR remove the
SUM
function. It's doing double work.
Lastly, you can select the range in the formula, like the k4, and click
on
another cell to change the reference.


"George A. Yorks" wrote:

I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of an
*rather than creating the formula manually each time
--
George

Thanks,
I don't know if what I'm trying to do is possible. I want to be able to
change each of the six designated cells by clicking on new cells. I now have
to delete the formula and re-create it. If I use ,", instead of + I can
change the first designated cell by clicking a new one. Will not however
move to each of the remaining letters and as you have said will not add.
Does this make sense as I've written it??
--
George


"Earl Kiosterud" wrote:

George,

you need the + operators if your intention is to add those cells. If you
use a comma, ROUNDDOWN will think you're giving it more arguments, and will
choke.

SUM(D4+F4+J4+O4+R4+S4) will add them up, but the SUM function isn't
necessary since you're explicitly summing them with + operators.
SUM(D4, F4, J4, O4,R4, S4) will add them up, as SUM takes up to 31 (I think)
arguments

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"George A. Yorks" .(donotspam) wrote in message
...
=ROUNDDOWN((((D4+F4+J4+O4+R4+S4)*3)-72)*0.8,0) This formula will add the
six
cells etc. If I change the + to ",", the formula will not calculate. I
can
click on a new cell and it will make the change but only in the first
position. Hope I have been clear enough with my explanation
--
George


"Bob Umlas, Excel MVP" wrote:

First, use "=" instead of "@"
Next, EITHER replace the "+" inside the formula with ",", OR remove the
SUM
function. It's doing double work.
Lastly, you can select the range in the formula, like the k4, and click
on
another cell to change the reference.


"George A. Yorks" wrote:

I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of an
*rather than creating the formula manually each time
--
George

George,

If you put the formula into edit mode (double-click or press F2), then the
colored reference boxes that appear can be dragged around to change the cell
references. Perhaps that would be suitable.

To be able to click them would probably require some event-driven macros.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"George A. Yorks" .(donotspam) wrote in message
...
Thanks,
I don't know if what I'm trying to do is possible. I want to be able to
change each of the six designated cells by clicking on new cells. I now
have
to delete the formula and re-create it. If I use ,", instead of + I can
change the first designated cell by clicking a new one. Will not however
move to each of the remaining letters and as you have said will not add.
Does this make sense as I've written it??
--
George


"Earl Kiosterud" wrote:

George,

you need the + operators if your intention is to add those cells. If you
use a comma, ROUNDDOWN will think you're giving it more arguments, and
will
choke.

SUM(D4+F4+J4+O4+R4+S4) will add them up, but the SUM function isn't
necessary since you're explicitly summing them with + operators.
SUM(D4, F4, J4, O4,R4, S4) will add them up, as SUM takes up to 31 (I
think)
arguments

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"George A. Yorks" .(donotspam) wrote in message
...
=ROUNDDOWN((((D4+F4+J4+O4+R4+S4)*3)-72)*0.8,0) This formula will add
the
six
cells etc. If I change the + to ",", the formula will not calculate.
I
can
click on a new cell and it will make the change but only in the first
position. Hope I have been clear enough with my explanation
--
George


"Bob Umlas, Excel MVP" wrote:

First, use "=" instead of "@"
Next, EITHER replace the "+" inside the formula with ",", OR remove
the
SUM
function. It's doing double work.
Lastly, you can select the range in the formula, like the k4, and
click
on
another cell to change the reference.


"George A. Yorks" wrote:

I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can
be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of
an
*rather than creating the formula manually each time
--
George

Just to say thank you for all the assistance
--
George


"Earl Kiosterud" wrote:

George,

If you put the formula into edit mode (double-click or press F2), then the
colored reference boxes that appear can be dragged around to change the cell
references. Perhaps that would be suitable.

To be able to click them would probably require some event-driven macros.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"George A. Yorks" .(donotspam) wrote in message
...
Thanks,
I don't know if what I'm trying to do is possible. I want to be able to
change each of the six designated cells by clicking on new cells. I now
have
to delete the formula and re-create it. If I use ,", instead of + I can
change the first designated cell by clicking a new one. Will not however
move to each of the remaining letters and as you have said will not add.
Does this make sense as I've written it??
--
George


"Earl Kiosterud" wrote:

George,

you need the + operators if your intention is to add those cells. If you
use a comma, ROUNDDOWN will think you're giving it more arguments, and
will
choke.

SUM(D4+F4+J4+O4+R4+S4) will add them up, but the SUM function isn't
necessary since you're explicitly summing them with + operators.
SUM(D4, F4, J4, O4,R4, S4) will add them up, as SUM takes up to 31 (I
think)
arguments

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"George A. Yorks" .(donotspam) wrote in message
...
=ROUNDDOWN((((D4+F4+J4+O4+R4+S4)*3)-72)*0.8,0) This formula will add
the
six
cells etc. If I change the + to ",", the formula will not calculate.
I
can
click on a new cell and it will make the change but only in the first
position. Hope I have been clear enough with my explanation
--
George


"Bob Umlas, Excel MVP" wrote:

First, use "=" instead of "@"
Next, EITHER replace the "+" inside the formula with ",", OR remove
the
SUM
function. It's doing double work.
Lastly, you can select the range in the formula, like the k4, and
click
on
another cell to change the reference.


"George A. Yorks" wrote:

I have created a basic formula @sum(b4+d4+h4+k4+l4+n4) the cells can
be
changed at any time. Is there any possible way to have these cell
designations changed simply by selecting the desired cells by use of
an
*rather than creating the formula manually each time
--
George