Drew,

You can use the SUMIF function. Let's say that you bills are in column A,
starting in cell A1, and you put PAID in column B when they are paid.

To get the summation then, use the formula (for the first hundred rows)

=SUMIF(B1:B100,"<Paid",A1:A100)

HTH,
Bernie
MS Excel MVP

"Drew" wrote in message
...
I have a column that sums. The column is a list of my bills; for example
$50,
$100, $150.

If I pay my $50 bill, i want to do something to the cell to indicate that
the bill is paid (maybe strikeout text, a green color or something), and
to
not include that bill in the summation.

Thanks in advance for your help