A spreadsheet application developed by Apple as part of its iWork suite. The iWork equivalent of Microsoft Office Excel.

learn more… | top users | synonyms

4
votes
3answers
1k views

Numbers: Countif with condition the content of a cell

I am struggling to come with a solution on this problem, making me wonder if the Countif function is designed to work this way, or what is wrong with my syntax at the end. I have my first table with ...
1
vote
1answer
39 views

Tracing the forward use of values in formulas in Numbers

I use Numbers version 3.1 on Mavericks. One can easily look at a formula in a given cell and immediately see the other cell references it uses. I think of this as a backwards look. Does any means ...
3
votes
1answer
56 views

Numbers 2: Create a new header cell, listing once the contents of a column

Not sure how to search for this question, and moreover I rather think that what I want might not be possible, but just in case I am asking it here. I am looking for a way to create a new table where ...
6
votes
2answers
5k views

Numbers v3.1: Automatically link URLs in spreadsheet?

I've inherited a spreadsheet that has a loooong column (thousands) of URLs, all unclickable. I'd like to make them clickable. I have tried the following: Highlighting the column. Select column, ...
2
votes
1answer
256 views

How do I sort a Numbers' table using data from another table?

So, I've got this data set coming from questionnaires. I created one table per question, questionnaires in rows, answers in columns, and everything is fine and dandy, but now I have this situation ...
2
votes
2answers
6k views

How to display zero value as blank cell in mac numbers 3.1

How do I display zero value as blank cell in mac numbers 3.1 yet maintain a formula. I want a running balance column that only shows balance to the line of the last entry like a checkbook register. ...
1
vote
0answers
114 views

How do you get different color bars in Numbers 3.1?

In previous versions including 3.0 when you made a 3D Bar chart each data point (ie. months) would be in a different color - now I can't seem to find any way to make them different. Is this a bug in ...
1
vote
0answers
47 views

Latest Numbers changes, how to graph things?

Ok this is insane, I have a table Selecting both columns, and What i get back makes no sense. Plotting columns as series i get Plotting rows as series i get Things worked perfectly fine ...
1
vote
1answer
319 views

Insert MathType Equation is disabled in Numbers

I am running Numbers 3.1. When I try to select the Insert > MathType Equation... option, it is disabled. There doesn't seem to be anything in the help related to this feature. How can I use this ...
5
votes
1answer
123 views

How to calculate max with condition in Numbers?

How can I calculate max with condition in Numbers? In other words, I want something like maxifs, which operates max operation instead of sum operation for sumifs.
1
vote
1answer
986 views

Updating a chart dynamically in Numbers

Background: I've been having some sleep issues so I have started tracking my sleep habits along with some other data but so far, they are just entries in Evernote and as such it is not possible to see ...
8
votes
1answer
6k views

Swap X and Y axes on Numbers 3.1

This link is now outdated with the new release of numbers. I want to transpose the X- and Y-axes on a chart in Numbers 3.1. How the heck can I do this? The first chart I made was able to sum my ...
2
votes
3answers
2k views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
2
votes
1answer
264 views

Reinstall Numbers?

I got myself into a state where App Store says that I have numbers "installed" but in fact I don't have it installed. I tried the recommended option/click and shift/click over the installed button and ...
7
votes
5answers
22k views

How to gracefully import CSV files into Numbers.app v3?

I have a process, which has worked faithfully for years in Numbers '09, whereby I download my Bank account data in CSV format, then drag that data directly into my Numbers sheet (after creating an ...
4
votes
1answer
576 views

Numbers: Grouping daily data into weekly data

I have a spreadsheet where I am keeping track of several statistics on a daily basis. I have another spreadsheet where I am keeping track of several statistics on a weekly basis. I want to graph the ...
3
votes
1answer
3k views

Numbers: conditonal highlight based on a date in a different column

In numbers, I would like to change the background colour of Column D based on whether the date in Column A is still in the future (i.e. graying out). I can get the colour formatting to work on the ...
6
votes
1answer
23k views

How to create sum in Numbers up to a specific row?

I have column which contains prices for my work. The last row of that column should contain the total. Currently I have to adjust the SUM() calculation every time I add or remove a row. Can I somehow ...
7
votes
1answer
13k views

How to uninstall Numbers and Keynote on Mavericks?

I installed Pages version 5 on Mavericks via the "App Store". But the problem is Keynote and Numbers are installed also. I'm not interested in Keynote and definitely not in Numbers. I want to ...
1
vote
2answers
2k views

Can I remove items from my App Store updates

The App Store wants me to update my Pages 4.3 to Pages 5.0. Given the changes to and reviews of Pages 5.0, I wish to stay with 4.3. Can I somehow delete the upgrade reminder from the list? I ...
6
votes
3answers
175 views

Is this possible to link the value to a database in Apple's iWork suite?

For example, I would like to make a Pages document that has a value that's linked to the company information and Keynotes and Numbers as well. So, when our company information changes, all the ...
4
votes
2answers
1k views

Numbers no longer opens .xls spreadsheet

I have very recently converted to a MacBook Air from a PC and have a 1.3mb .xls file which 1 week ago Numbers happily opened, edited and saved in its own format. Today, when I opened it it was ...
3
votes
1answer
5k views

Keyboard shortcut to delete row in Numbers

I can add rows conveniently using Option+Shift+Up Arrow (insert above) or Option+Shift+Down Arrow(insert below). Is there a keyboard shortcut to delete the current row?
1
vote
1answer
1k views

Numbers: How to change cell text conditionally?

I am trying to change the text of a cell in Numbers 3 according to a condition. E.g. if A1-A2 is a negative value, the text shall be 'Negative'. If the value is positive the text shall be 'Positive'. ...
0
votes
2answers
4k views

Insert date & time in latest version of Numbers

I've looked around online and have found references to an "Insert => Date & Time" capability in Numbers for OSX. But it's not there in my version of Numbers (3.0.1 -- 1483). Has this capability ...
3
votes
1answer
682 views

Numbers 3 - How to apply custom chart style

Using Numbers 3.0 with Mavericks. I am creating a bunch of scatter plots in numbers. I want to remove the big bubbly data point symbols and simply display the data as connected points. Setting this ...
4
votes
2answers
921 views

How to write AND condition in Numbers

I have a dataset where I want to write a COUNTIFstatement in Numbers (Mavericks). Specifically I want to count if a number is between 16 and 30. So far I have tried: COUNTIF(test-array, ">15 AND ...
5
votes
2answers
10k views

COUNTIF using two conditions from data inside and outside the dataset

I'm struggling to use numbers to do a function. Specifically, I want to use COUNTIF to check two things within my data set table and put that information into another table that we'll call "query ...
12
votes
4answers
39k views

How can I do text-to-columns in Numbers?

I've got a column where each cell in the column contains two different pieces of data separated by a known delimiter ", ". How can I split each cell in this column around the delimiter? Given: ...
1
vote
0answers
43 views

iWork Numbers 3: detect change in row

I'd like to update the datetime in a cell whenever any cell in the row changes. Is this possible in iWork Numbers 3? If not possible to look for changes in entire row then perhaps only "watching" a ...
0
votes
1answer
53 views

Where has Numbers gone?

I created several spreadsheets in Numbers. Lately I have been using Excel, which won't open them. I can't find Numbers in my application folder--is it hiding somewhere??
0
votes
1answer
2k views

Mac Numbers date functions

Can I colour a cell red if todays date is on or after the date I have entered in the cell? I have tried the IF function and conditional formatting but cannot make it work...
0
votes
2answers
79 views

Numbers.app - How do I add a series of columns

I have a spreadsheet with about 600 rows and 20 columns. I want to add a unique identifier to each cell so that I can use the exported CSV output in another app. So I thought that I could add a ...
3
votes
2answers
2k views

Can't email Numbers 3.0 or Pages 5.0 documents via Google Mail (Gmail)

When I try to email a Numbers 3.0 or Pages 5.0 document via Google Mail, I receive the following error.
2
votes
1answer
5k views

Numbers Won't Open On My MacBook Pro with OS X 10.8.5

I'm not a tech or computer expert - I understand clear directions, but not tech-speak, so I'm going to put this as plainly as I can… I've updated to the most recent system, OS X 10.8.5, on my MacBook ...
1
vote
1answer
353 views

Any suggestions for an ultra-lightweight spreadsheet-like application?

Does anyone have a suggestion for an ultra-light spreadsheet application which is very fast and snappy? I do most of my deep analysis using advanced statistical programs and I manipulate ...
1
vote
1answer
2k views

New Numbers has no Auto-Complete?

It would appear that my documents in Numbers (since upgrading to 3.0 with Mavericks) no longer auto-complete cells. I've Googled for "turn on auto-complete in Numbers" and found plenty of questions ...
5
votes
3answers
2k views

How to store new iWork (2013) documents in a flat file (for version control)?

With the October 2013 iWork update, the new UI is great but it seems one cannot store documents as 'flat file' any more. This really limits my ability to store the files, essentially ruling ...
0
votes
1answer
121 views

Numbers has stopped showing up in Launchpad

Numbers has stopped showing up in Launchpad. How can I add it back?
1
vote
0answers
200 views

Is there a way to create a polar plot in Numbers?

I am trying to do a polar plot, or radar chart as excel calls them, for a report. I don't have excel, only Numbers, is there a way to do that type of plot with Numbers? I can't seem to find a way. The ...
1
vote
1answer
86 views

Performance of Numbers 3.0 for large calculation sheet

When I used previous versions of Numbers to work with files containing a lot of large formulas, the performance of many actions were slow, including scrolling. Can you comment how about the latest ...
0
votes
2answers
60 views

Numbers floating sheets

In Numbers, how can I get the spreadsheet to remain stationary on the page? I have tried to double tap thinking that would display and anchor the sheet but it doesn't work.
1
vote
1answer
3k views

How do I sum up specific things in Numbers?

I have a spreadsheet in the newest iWork Numbers.app, with something like: CATEGORY | POINTS HW | 100 HW | 100 NW | 12 HW | 50 NW | 23 I want to just sum up all the ...
0
votes
2answers
1k views

Numbers regex for stripping domain from email address

I have a field that contains email addresses, I want to use regex to strip everything before the @ symbol to give me just the domain e.g. john@apple.com => apple.com jill@apple.com => apple.com ...
0
votes
2answers
613 views

Numbers spreadsheet can't be imported

I have a spreadsheet I have been updating in IOS Numbers for several months and I sometimes update it with OSX Numbers However when I did a recent update in OSX I get the error message Spreadsheet ...
1
vote
1answer
205 views

Exporting CSV with Numbers with different languages

I am exporting a file from Numbers to CSV and it contains language other than English, like Japanese or Russian. After I export the CSV, all these funny characters shows up in the CSV. Is there a ...
2
votes
1answer
6k views

How to change cell background color in numbers according to some rules?

Making it simple, using Numbers, how can you set up the following: If number is positive make background cell green, else make it red
1
vote
1answer
802 views

Converting a float to hours:minutes in Numbers

Probably this is a very easy thing to do, but as handicapped as I am using Apple's iWork applications, I just can't find it. I have made a calculation in Numbers which results for example in 14,25 or ...
2
votes
1answer
42 views

How to make Numbers accept the “.” instead of the comma “,” when inserting data?

I'm from elgium. In Dutch, as probably in some other languages, you write numbers like this: 3,141592, where in English it'd be 3.141592, but the Numbers app only interprets my input as a number when ...
0
votes
1answer
104 views

How to stop Numbers from beeping at me when I use the arrow keys?

When I edit spreadsheets in Numbers, I often hold down the left or right arrow key to get to the far-left or far-right column of a table. Numbers always beeps at me when I do this. It seems to think ...