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

learn more… | top users | synonyms

3
votes
0answers
1k views

How Do i Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already got a clue of how to use SUMIFS to create Pivot Table in Numbers. But i'm still looking for a better answer of how to generate the ...
2
votes
0answers
48 views

Changing the open with settings in 10.10.1

I am looking for a way to edit the open with settings in 10.10.1, i have looked through older questions and have attempted to rename the launch services plist and have gotten no where. I have looked ...
2
votes
0answers
201 views

How to use an array as a condition in a COUNTIFS or SUMIFS formula

This question could be tricky to follow so I'll split it out with examples Given I have this table of overpriced fruits; Item Price Apple £0.80 Peach £1 Pear £1 ...
2
votes
0answers
37 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 ...
2
votes
0answers
84 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
0answers
38 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.
2
votes
0answers
144 views

What is the Numbers keyboard shortcut to get in the formula bar of a cell?

I am looking for a keyboard shortcut in Numbers to edit the current cell via the formula bar (if that is the right word). Screen shot: Please note, I am not looking for this answer. That is how to ...
1
vote
0answers
11 views

How can I link data from Numbers to a Pages document?

I'd like to have all my client invoices in a Numbers document, including invoice number, service period, daily rates,... and generate a invoice from that with a template I have created in Pages. How ...
1
vote
0answers
26 views

How to get long decimals from functions in Numbers?

I am using Numbers on OS X to help me with a GIS project; I have created a .CSV file that describes a polygon in terms of the distance and bearing between any two consecutive vertices. Using the ...
1
vote
0answers
292 views

App Store Purchase Update gives “An error has occurred” messages for Keynote and Numbers

I am trying to install Keynote, Pages, and Numbers from my App Store account using my Apple ID and password. Pages has installed properly and works. Numbers and Keynote both failed and do not open. ...
1
vote
0answers
155 views

Numbers app: how to change x axis position + change chart's line width

I have a regular linear graph and have y values running from negative to positive, enabling x axis shows the line at the bottom of the graph. How is it possible to set it to show at zero, i.e. running ...
1
vote
0answers
103 views

How can I restore an older version of a Numbers document (before the sync)

I'm using Numbers on my iPad and my Macbook. Yesterday I opened my Macbook and for some reason it opened the Numbers app but didn't sync. I didn't really need to work on the file so I just left it ...
1
vote
0answers
67 views

Can't use any of the iWork apps

I'm unable to use any of the apps included in the iWork package. If I try to open any one of them, the app opens but I can't perform any action. I click on the bar menu items to see that even 'About ...
1
vote
0answers
33 views

Sum of Formula results?

Is there any way in Apple Numbers to apply a formula to a selected set of rows, and sum up the results? This is how i'd like to have/use the formula SUM(TableA::$A$1:$A$20;"=$1*"&TableB::A1) ...
1
vote
0answers
41 views

How to write a function in Numbers to get the DATES for different tasks

I am trying to figure out how to write a function to get Dates going on and back from a different moments in my to-do spreadsheet. I know that i can use function DATEVALUE() to count from one specific ...
1
vote
0answers
51 views

Numbers '08: How to create a histogram?

I have data (ranging from 0 to 1, e.g. 0.61 0.23 0.99 1.0 0.89 0.0 0.42 0.42 0.86 and I would like to create a histogram with bins 0 0.2 0.2 0.4 0.4 0.6 0.6 0.8 0.8 1.0 with the upper ...
1
vote
0answers
77 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
31 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
0answers
97 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
0answers
113 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 ...
1
vote
0answers
83 views

Is there a way to have a formula in numbers 09 return an empty value (ie isempty() returns true?)

I've got a list of times and ages, and want to extract ages for a particular range of time values. So I've used an 'if' formula to copy the age for an entry if its time is between two values. The ...
0
votes
0answers
17 views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
0
votes
0answers
13 views

How to highlight or filter for duplicate values in a column in a Numbers spreadsheet?

I have a Numbers spreadsheet with a few thousand rows containing a column with phone numbers. As part of a cleanup of the sheet, I need to identify rows where the phone number has been duplicated so ...
0
votes
0answers
7 views

Apple numbers '08: extending a formula

how can i get a formula to apply to every cell in a column (i.e., i want to subtract a number I just entered in one cell from a total I have in a previous cell and I want to do it each subsequent cell ...
0
votes
0answers
18 views

Apple Numbers 3: how to set a background-color for the whole paper?

I want to set the backgroundcolor (in Numbers 3) of the paper to specific color. I tried to fill the cells but it does not work. I tried to to do it with an rectangle but it does not work. See the ...
0
votes
0answers
8 views

Numbers Full Screen on iPhone

I have recently got an iPhone. I transferred some of my Numbers spreadsheets. I expected these to be smaller than on iPad and Mac, but 20% of the screen is used for menu and list of sheeets (even on a ...
0
votes
0answers
29 views

Numbers for Mac: Force line chart to show axis at point (0, 0)

Look at this line chart. I wonder if its possible to force Numbers to show Y=0, for example, without needing to add a data entry point to make it happen. - Is it possible?
0
votes
0answers
59 views

How to insert a “pop-out image thumbnail” into a cell in Numbers?

I have a Numbers document where I would like to insert images into each cell in one of the columns, in one of my data tables. The images are quite large, so I would like to insert the images as a ...
0
votes
0answers
44 views

Locally created excel file does not open in Numbers

I have a local process which creates an excel file using the python library openpyxl. I am not able to open the file in Numbers. When I try I receive the simple message "filename can't be opened." I ...
0
votes
0answers
15 views

Writing Text in Cells in Numbers

How do I get the cell in numbers to expand but not merge with the other cell when the text is too long? Like, I want it to stay in the same line, unlike wrap where it'll just force the text down. ...
0
votes
0answers
16 views

How can Apple iWork's number generate the empty data field?

The left is excel and the right is number. I would like to do the result like the left one, and how can I do it in number? Thanks.
0
votes
0answers
23 views

User stylesheet / formatting for all osx apple apps

I'm increasingly spending lots of time tweaking text formats from one document to the next, updating styles, formats and generally improving them. Is there a way i can export styles from numbers, ...
0
votes
0answers
65 views

Can't open Numbers, but can open Numbers.app/Contents/MacOS/Numbers

Okay, this is weird. I can't open Numbers by trying to open the .app file, but I can open it by drilling down into the app and opening Numbers.app/Contents/MacOS/Numbers via terminal. Anyone have ...
0
votes
0answers
27 views

How to update the formula in a column without deleting comments using Numbers for Mac

The question pretty much sums it up, I have a huge sheet with many calculated cells, conditional formatting and comments. In one column, lets say column K, I have a formula similar to this, ...
0
votes
0answers
23 views

Numbers never responds

When I try to run Numbers, it bounces for a while, and then just stops. No windows, no menu bar, nothing. When I Ctrl-click the icon, it says not responding, so I force-quit. I have never actually ...
0
votes
0answers
31 views

Does numbers have a way to auto-fill an entire column?

Excel has a feature where when you are trying to auto-fill equations (i.e. you can drag an equation down and it makes an appropriate equation for the next row), you can double-click the drag-handle ...
0
votes
0answers
42 views

Entering only the time in a iOS Numbers form

I use Numbers on my iPhone to keep track of a few things that have well-defined attributes. Each of these documents has a sheet that acts as a simple database, and a form that I use to enter rows into ...
0
votes
0answers
30 views

Numbers 'Not Responding'

I have a problem opening one particular Numbers spreadsheet on some of our computers but not others. All are running 10.8.3 any clues? I have tried changing the file name, holding down the shift key ...
0
votes
0answers
34 views

Loading xlsx file in Numbers, Filter Table is disabled on columns

I loaded an Excel file (XLSX format) with a table in Numbers, where I had filtered out some data based on a column (using Excel's column-based filtering options). In Numbers, I only see the filtered ...
0
votes
0answers
78 views

Removing random gridlines in Numbers

How can I remove gridlines in Numbers? I have cleared all the gridlines and still can't remove from two rows. Is there a way to remove them?
0
votes
0answers
20 views

Maverick update to network and now Numbers documents on server locked

We updated Macs on network that are new enough to Mavericks. This included the server. Now all the Maverick computers are locked out of Numbers documents on server. The non Maverick computers can ...
0
votes
0answers
134 views

Copy Paste formula in Number 3.2

I have20 three-member groups with different individual measures. So, I have a sheet in which I have 60 (20*3) rows and number of columns )+ heading row). I also have another sheet in the same file ...
0
votes
0answers
65 views

How to display labels on bubble chart, Numbers (v3.2)

I want to display the label of each bubble on a bubble chart in numbers. How do you do this? I want either a truncated "description" or the 3-digit NAICS to be the label of the bubble. Here's an ...
0
votes
0answers
49 views

How to calculate total rental income of a property in Numbers?

I'm trying to calculate the total rental income of a property which increases in value over time. If I assume that the rent will always be 5% of the property value, and that the property is initially ...
0
votes
0answers
38 views

Numbers 3.1: Maintain Link to CSV

Is there a mechanism to maintain a link between a CSV that may change and a Numbers file? I would like to maintain a Numbers file that uses table data from a CSV whose contents will be updated every ...
0
votes
0answers
40 views

Map date and time entries to single day in Numbers

I am keeping track of a certain value that varies during the day, and from day to day. I make entries in my Numbers table as I get the values during the day. Column A is the time entry: month day year ...
0
votes
0answers
31 views

iMac OS X 10.9.1

I am a new user of Macs and Numbers and need a little help. I am creating a Numbers page for a game I play in which I have multiple trains with various loads they can carry. I have entered this data ...
0
votes
0answers
16 views

Copying - Old Version vs. New Version of Numbers

I use Numbers for a relatively primitive way to catalog books I have read. The old version would copy the date (month/year) and the author's name once I entered the first couple characters. Now I have ...
0
votes
0answers
36 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
0answers
116 views

How do I evaluate multiple equations in a single cell?

I have two equations in a Numbers spreadsheet: COUNTIF(PROMO,FALSE) COUNTIF(Purchases :: WL,FALSE) I need to merge these to satisfy one cell's value. Something similar to countif( A && B , ...