Thread: Simple subtraction and color coding ?

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

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


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

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

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)