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