Not counting values if strikethrough in iWork- Numbers

Posted by Stoosh on Super User See other posts from Super User or by Stoosh
Published on 2010-06-16T00:45:48Z Indexed on 2010/06/16 0:53 UTC
Read the original article Hit count: 400

Filed under:

spreadsheet

|

iwork-numbers

I'm building a holiday expense planner and I'm trying to get the sum of a column in a table, however as I pay things off I want to be able to strikethrough the amount and then it minus it from the total sum.

Is this possible with Numbers?

© Super User or respective owner

Related posts about spreadsheet

Error while reading from spreadsheet in Ruby

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting following error while reading from a spreadsheet file. I have searched alot on Google. I have seen posts with similar problems but no reply to the problems. Does anyone know how to resolve this error? C:/Ruby/lib/ruby/gems/1.8/gems/ruby-ole-1.2.8.2/lib/ole/storage/file_system.rb:125:in… >>> More
Copy and paste the data one Excel spreadsheet to another spreadsheet based on column name

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to copy and paste the data from one Excel spreadsheet to another based on column name. For example, one shreadsheet has columns named like Asset, Asset owner. Another spreadsheet has column named like Application, Application Owner. Now I want "Asset" column data to copy and paste into the… >>> More
search & replace on 3000 row, 25 column spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm attempting to clean up data in this (old) spreadsheet and need to remove things like single and double quotes, HTML tags and so on. Trouble is, it's a 3000 row file with 25 columns and every spreadsheet app I've tried (NeoOffice, MS Excel, Apple Numbers) chokes on it. Hard. Any ideas on how else… >>> More
Translate report data export from RUEI into HTML for import into OpenOffice Calc Spreadsheets

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A common question of users is, How to import the data from the automated data export of Real User Experience Insight (RUEI) into tools for archiving, dashboarding or combination with other sets of data.XML is well-suited for such a translation via the companion Extensible Stylesheet Language Transformations… >>> More
What is spreadsheet useful for?

as seen on Programmers - Search for 'Programmers'
I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting tables, or as an ad-hoc database that could have been maintained in a text-file. I had to do heavy data-processing… >>> More

Related posts about iwork-numbers

Paste a list of dates in format of "mm/dd/yy" to iWork-Numbers

as seen on Super User - Search for 'Super User'
I have trouble to paste a list of strings in the format of 'mm/dd/yy' into iWork-Numbers. For example, I have a list of strings(text in VIM): 04/01/10 04/03/10 04/13/10 I copy those strings and then paste into my iWork-Numbers worksheet. The result will be: 2004-01-10 2004-03-10 04/13/10 It… >>> More
Paste string of date format mm/dd/yy to iWork-Numbers

as seen on Super User - Search for 'Super User'
I have trouble to paste a list of strings in the format of 'mm/dd/yy' into iWork-Numbers. For example: 04/01/10 04/03/10 04/13/10 The result will be: 2004-01-10 2004-03-10 04/13/10 It looks like that Numbers convert the mm into year, then month and last day. Is there any way to paste whatever… >>> More
Not counting values if strikethrough in iWork- Numbers

as seen on Super User - Search for 'Super User'
I'm building a holiday expense planner and I'm trying to get the sum of a column in a table, however as I pay things off I want to be able to strikethrough the amount and then it minus it from the total sum. Is this possible with Numbers? >>> More
Val2 function in iWork Numbers?

as seen on Super User - Search for 'Super User'
Is there equivalent Excel Val2() function in Numbers? I want to get value of a cell, which contains formula. What I need to get the result text from the cell. The following is example data: A B C ? 0 what? For example, in cell A1 I have a function like: =Right(C1) which is the end character… >>> More
Iwork Numbers Spreadsheet Referencing

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to Mac Numbers. I would like to know if there is a way that one spreadsheet can reference the values from another spreadsheet. >>> More