Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exclude a cell from calculating
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 |
#2
|
|||
|
|||
Hi!
Why not use a helper column. If you list your bills in column A, in column B put an "X" in cells next to bills that have been paid. Then you could use a formula like this: =SUMPRODUCT(--(B2:B10<"X"),A2:A10) Biff -----Original 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 . |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8. | Excel Worksheet Functions | |||
after calculating, round a cell value | Excel Worksheet Functions | |||
Calculating on alphabetic cell content | New Users to Excel | |||
calculating with a time format cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |