Biff,
Thank you very much. Both of these formulas work great.
Are they both the same formula except for the "" and the "0"? Or are they
meant to be imbeded within each other?
"Biff" wrote:
Hi!
Try this:
=SUMIF(B1:B10,"",A1:A10)&" remaining and "&SUMIF
(B1:B10,0,A1:A10)&" already forfeited"
Biff
-----Original Message-----
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 ?(TBD)
8 ?(TBD)
6 ?(TBD)
3 ?(TBD)
A11=55 B11=26 Total of B1:B10 C10= 55-26
(24 remaining and 5
already forfeited)
Thank you in advance,
Judd
.