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

learn more… | top users | synonyms

13
votes
4answers
889 views

How to Change File Type Associations?

How do I stop Numbers from being the default program when a financial file is downloaded or imported?
6
votes
1answer
13k views

How do I do a pivot table in Numbers?

I can't find any equivalent of the Excel Pivot Table or Open Office Data Table features. I'd like to sum up my data grouped by values in various columns. For example, if I have A B C red ...
3
votes
1answer
7k views

Conditional SUM() based on text of a cell using iWork

I have some basic data Name | Amount Jake | 10 Jake | 12 Jake | 13 Ben | 1 Ben | 14 Ali | 9 Ali | 4 I want to total up the amount for each person so I end up with something like Jake | 35 Ben ...
1
vote
1answer
240 views

Charts from numbers not dynamically updating in Pages/Keynote

I have the latest (5/2015) Pages, Numbers, and Keynote on Yosemite. I created a chart in numbers and then copied it to Pages or Keynote. I then want to be able to change the data in Numbers and see ...
1
vote
1answer
4k 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 ...
10
votes
2answers
4k views

Is there a keyboard short cut to edit a cell in Numbers?

Back when I used Excel you could easily do all the navigation and editing on a spreadsheet with the keyboard. I could navigate around with the arrow keys and hit F2 to edit a cell and start typing. ...
3
votes
2answers
13k views

Swap X and Y axes in Numbers?

I'm taking an economics course, and for whatever reason economists create graphs with the independent variable (price) on the Y axis and not the X axis. If I only have 1 dependent variable to graph, ...
2
votes
1answer
390 views

Count contents of one column if an adjacent cell matches a query in Numbers

I have a spreadsheet maintained in Numbers where I record my practices at the range, which lists type of weapon (pistol, rifle, shotgun), as well as the numbers of shots fired. I am readily able to ...
2
votes
2answers
5k views

How to export Contacts version 9.0 data or .abbu file to .csv or other usable spreadsheet format

In the newest Apple Contacts version 9.0, how do you export all contacts or an .abbu file to a .csv file or other usable spreadsheet format? Dragging and dropping to Numbers does not work. Exporting ...
2
votes
1answer
4k views

How can I add custom error bars to a graph in Numbers

I am using numbers 2014 - above is a screenshot that should explain it.
1
vote
1answer
437 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?
1
vote
1answer
379 views

Can Numbers create stacked column charts with two columns for each category?

I'm trying to create a column chart in Numbers where each column is also stacked. For example, consider the following data. Here we have numbers for the total sample and numbers for how that total ...
1
vote
1answer
8k views

How to plot a histogram to show occurrence of a certain number using Numbers

Sorry for this newbie question: I want to do something like in a column there are numbers 0.2, 0.3, 0.2, 0.4, 0.2 occur 2 times, whereas 0.3 and 0.4 occur once, I want to make make histogram that ...
0
votes
1answer
2k views

Numbers auto date on template only

Is it possible to use the =today() function (or something else) to insert the current date but then not update each time the file is opened? I want to create a numbers template for my invoices. I'd ...