Simple subtraction and color coding ?

[needtolearn]

Can anyone help me? I am trying to do a simple subtraction formula.
will try to explain. I want to take the values of everything in E
through E45 away from the value of E2. The answer to that formula wil
end up in E(Whatever).

The second question is in the conditional area. I want to make it s
that excel will only take numbers displayed in certain colors and pu
them in the correct place. I have two columns, one will be for on
account and another for a differant account. I want to asign a seperat
color to each account and then add values in the rows that are colo
coordinated for a specific value in a column. This value will then b
the one that I mentioned in the first question for the subtractio
formula.


I just can't figure it out by myself, I am in need of a friend that ca
help me with this stuff. I am spending to much time racking my hea
trying to figure out the help menue for Microsoft. Might as well be i
Chinese. Ha Ha. :confused

 

[daddylonglegs]

Is this two separate questions?

Possibly

=E2-SUM(E3:E45) for the first

For the second....

where does the colour coding come from, is it conditional formatting?
If so is that triggered by the account number? Can you use a SUMIF
formula based on the account number, e.g.

=SUMIF(a:a,c1,b:b) where c1 contains relevant account number

 

[curlydave]

need more claification,
from E3 away from E2:E45
WITHOUT A CIRCULAR???
=Sum(E3:E45)
-E2
so =sum(E3:E45)
Therefore
E46==E2-SUM(E3:E45)