LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Drew
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8. garpavco Excel Worksheet Functions 3 August 18th 05 01:22 PM
after calculating, round a cell value C Excel Worksheet Functions 3 January 11th 05 08:12 PM
Calculating on alphabetic cell content Thorkild New Users to Excel 5 January 11th 05 03:12 PM
calculating with a time format cell Mahnaz Excel Worksheet Functions 1 December 13th 04 10:21 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"