I am looking for a points remaining formula that will calculate a column say
from 1-10 and tell me what numbers have been used and what numbers are left.
This will be a running total that calculates point totals so the maximum
total if all requirements are met would be the total of A1:A10 in B10 (55).
But some of the requirements are not always met so the cell will not be
awarded a point value. The formula would be for column C10 where it would
calculate the total possible (55) €“ points assigned in each cell. Because
this is a running total I have some cells that have not been determined yet.
It will basically go through column A and say ok there are (55) possible
points then it runs through column B and say as of B6 the total is (26) out
of (55) with (24) possible remaining and (5) already forfeited for a total of
(55).


A B C
2 2
1 0
10 10
5 5
4 0
9 9
7
8
6
3
A11=55 B11=26 Total of B1:B10 C10= 55-26-(24 remaining +5 forfeited)
for a total of (55)




Thank you in advance,


Judd