software

ok,

heres what i am trying to do now, lol.

Take two cells one will be the projection say 10
the other will be actual say 9
can excel tell me that equals -1 ?
i mean minus one from the projection not a negative number
and if so then can it cumulative totals of that ?
say i have projections in different cells ex: 9,10,11,12
the actual numbers below would be 9,11,8,10
so the formula needs to tell me first one is qual second plus 1 third
minus 3 forth plus 2 and so forth and once it gives me those then total
them in colum so would total minus 4?

sorry hard to explain

TIA--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=505016
Assuming your projections are in A1:A4 and actuals in B1:B4. In C1
enter

=(B1-A1) and copy down to C4. This will return the values (I used your
posted data) of 0,1,-3,-2. In C5 then SUM(C1:C4) which returns the -4.Does that help?

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=505016Can they be seperated into seperate colums? if so, it should be easy
(assuming the same number of columns everytime.)

9101112
911810
01-3-2-4

Formula for A3 is =A2-A1 copied to B3 through D3. And then formula for E3 is
=SUM(A33)

If they needed to be in just one cell seperated by commas, it might be
doable, but probably wouldn't be easy, especially if the count of numbers
varied. Somebody could probably come up with a formula to do it, but it
would probably be able to do with VBA.

--
Kevin Vaughnquot;darkbearpooh1quot; wrote:

gt;
gt; ok,
gt;
gt; heres what i am trying to do now, lol.
gt;
gt; Take two cells one will be the projection say 10
gt; the other will be actual say 9
gt; can excel tell me that equals -1 ?
gt; i mean minus one from the projection not a negative number
gt; and if so then can it cumulative totals of that ?
gt; say i have projections in different cells ex: 9,10,11,12
gt; the actual numbers below would be 9,11,8,10
gt; so the formula needs to tell me first one is qual second plus 1 third
gt; minus 3 forth plus 2 and so forth and once it gives me those then total
gt; them in colum so would total minus 4?
gt;
gt; sorry hard to explain
gt;
gt; TIA
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=505016
gt;
gt;


Thanks, Kevin and Steve

Thats what I need but my problem is like you mentioned kevin in E4 it
gives the correct whole total but i need to keep a running total for
each cell so in other words one cell will say its minus 1 for that or
whatever and the next might be plus 2 ok under those in another cell
can it give me the running total of the plus 2 minus 2 or whatever the
actual numbers are ?--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=505016
Thanks, Kevin and Steve

Thats what I need but my problem is like you mentioned kevin in E4 it
gives the correct whole total but i need to keep a running total for
each cell so in other words one cell will say its minus 1 for that or
whatever and the next might be plus 2 ok under those in another cell
can it give me the running total of the plus 2 minus 2 or whatever the
actual numbers are ?--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=505016I'm not sure I understand what you want, but I took a shot anyway. If this
is what you mean:

9101112
911810
01-3-2-4
01-2-4
then the formulae in the 4th row a for A4: =A3
For the rest: =A4 B3 (and copied across)

HTH
--
Kevin Vaughnquot;darkbearpooh1quot; wrote:

gt;
gt; Thanks, Kevin and Steve
gt;
gt; Thats what I need but my problem is like you mentioned kevin in E4 it
gt; gives the correct whole total but i need to keep a running total for
gt; each cell so in other words one cell will say its minus 1 for that or
gt; whatever and the next might be plus 2 ok under those in another cell
gt; can it give me the running total of the plus 2 minus 2 or whatever the
gt; actual numbers are ?
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=505016
gt;
gt;


yes that was exactly what i meant! Thanksssssss--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
View this thread: www.excelforum.com/showthread...hreadid=505016You are welcome.
--
Kevin Vaughnquot;darkbearpooh1quot; wrote:

gt;
gt; yes that was exactly what i meant! Thanksssssss
gt;
gt;
gt; --
gt; darkbearpooh1
gt; ------------------------------------------------------------------------
gt; darkbearpooh1's Profile: www.excelforum.com/member.php...oamp;userid=30640
gt; View this thread: www.excelforum.com/showthread...hreadid=505016
gt;
gt;