minus number from cell and result in specific cell and specific column

What is the formulas for these two questions

First question

What I want is like this

I have number in cell (A1) = 100
when I enter number in any cell of column(B) for example (B1)=10
then in cell (C1) the result of (A1) - (B1) = (90)

and if I add in cell (B2)=10
then in cell (C1) the result of (A1) - (B1+B2) = 80 .accumulatively in cell (C1)

and any number in column (B), the result will be (A1) minus any number in column(B) accumulated in (C1)

<<<<<<<<<<<<<<<<<<<

second question

As above, but some thing is different which is

I have number in cell (A1) = 100
when I enter number at cell (B1) = 10
then the result would be in the adjacent cell (C1) = (A1) - ( B1) = 90
and If I enter a new number in cell (B2) = 10
then the result would be in the adjacent cell (C2) = (A1) - (B1+B2) = 80
and If I enter a new number in cell (B3) = 10
then the result would be in the adjacent cell (C3) = (A1) - (B1+B2+B3) = 70
and so on ..

I want the result to be add automatically to adjacent cell in column (C)

1. In cell C1, put the formula:
=A1-(SUM(B:B))

2. In cell C1 put this formula and then copy it down the C column:
=IF(ISNUMBER(B1),$A$1-(SUM($B$1:B1)),"")

Enter that carefully, copying it down WILL change formula in each cell if entered correctly.

Please Login or Register  to view this content.

enter that in C1

You can drag it down as many rows as you like, it'll adapt to the row it's on.

I can't tell what's different between your two questions.

EDIT:
Oh I didn't see that the first one always totalled in C1