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

learn more… | top users | synonyms

2
votes
1answer
44 views

OS X Numbers: How to use a spreadsheet value as a label

I have a basic spreadsheet chart, which also includes a single labeled cell (set as a slider) that is used as a constant multiplier. (In this case, it is used to vary the number of workdays.) I ...
0
votes
0answers
17 views

Numbers horizontal bar plot to vertical

When I make a barplot of my data with insert > charts > 2D barplot I get the below chart. However, I want the the bars to be vertical instead of horizontal. How can I do this in numbers?
0
votes
1answer
79 views

OS X Numbers. Column labels to numbers

HiI am using Numbers on OS X It show me column names with letters But I want to show it with numbers, like Rows. Thank You.
1
vote
0answers
49 views

How to export a table with transparency from Numbers to PNG?

If I copy a table from Numbers to the pasteboard and then create a new document in Preview, it usually works fine, but if cells contain partially transparent background or border colors (especially ...
0
votes
0answers
29 views

How to default format in Numbers so all cells include 2 decimal points

I need to default all Numbers documents so that all cells within any Numbers spreadsheets include two (2) decimal points.
0
votes
1answer
83 views

Apple Numbers x-axis “Value Labels” can't be set to “Date & Time” or “Duration”

I am graphing a two-column data set that looks like this: 1/1/1963 3,209,827,882 1/1/1964 3,281,201,306 1/1/1965 3,350,425,793 But when I try to set the Value Labels in either a Line Chart ...
1
vote
1answer
59 views

Count checked cells if cell on same row matches state in Numbers

Following on from my previous question, I also record which entry records a competition. These are currently recorded as checkboxes. Counting them all is easy enough; I simply use the following ...
2
votes
1answer
211 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
52 views

Numbers: how do I create a column with a sequence of times?

In Numbers, I would like to create a column with automatically generated cells to create a timetable with each hour and each half hour. I create a new document, type in "7:30 AM" and then in the cell ...
0
votes
2answers
77 views

How do I add cells together on OS X numbers app

What format should the cell be? This can not be added and only gives a exclamation mark - "the formula contains a syntax error. OS X and numbers v3.5.3
0
votes
1answer
80 views

Link tables for auto new rows - Numbers

Is there a way I can "link" tables in Numbers so that when rows are added to the "master" table that the identical rows and containing data are added in a linked table? I know I can "link" cells using ...
2
votes
0answers
165 views

Adding standard deviation (custom) as error bar in Numbers v3.5.3

Qn similar to How can I add custom error bars to a graph in Numbers. I'm not able to modify and/or customize error bars even after clicking on the graphical error bars for each series as mentioned in ...
0
votes
0answers
40 views

How do I do a pivot table MAX summary function in Numbers for iCloud?

I can use SUMIFS to sum data grouped by values but how would I get the max value of a group? This is Numbers for iCloud. For example, if I had A B red 2 red 3 green ...
0
votes
1answer
12 views

Apple software - Numbers [closed]

How do I identify and add(sum) only specific cells in a row - they are not continuous cells. Ex. I1, O1, U1 total sum and show in BG1
0
votes
1answer
154 views

How do I plot two data streams in Numbers as a graph?

I have two different streams of fractional values I want to visualize using Numbers for Mac. They both have one value per line and both look would look something like this (with different values ...
1
vote
2answers
79 views

Looking for charting recommendations beyond Excel and Numbers

Recently both Numbers and Excel failed me in my charting needs. I got the job done in Numbers, but only with brute force by creating 28 charts in what should have been two. Back in the 90s, when I ...
1
vote
1answer
153 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 ...
0
votes
1answer
30 views

How to change the default format in Numbers?

When using Numbers and I want to underline a cell, the default format is outlining the whole cell. I want the default format in Numbers to be only an underline not a box. Any way to do this?
0
votes
1answer
93 views

Filter by column in Numbers [closed]

I have blanks in each row. Can I hide them? I want to be able to select a row and gather it together by getting rid of the empty cells.
0
votes
1answer
22 views

Apple Numbers using AND in formula to find dupes

I don't get it how to use multiple conditions in the following case... IF(COUNTIF(name,name)>1 AND(ISBLANK(meaning)),"x", "") What this should do is compare the cells in column A (name) for ...
1
vote
0answers
160 views

how to conditionally ignore cell when applying sumproduct using Numbers (Mac)

Under Excel, there's something like = Sumproduct((A1:A100),--(A1:A100<>"")) from Excel formula -> how to change SUMPRODUCT formula to skip null cells But it did not work for Numbers. Wondering if ...
1
vote
1answer
158 views

Total per month of daily values

I would like to have a total per month in second table of the first table I would like the table to be separated and I would like the process to be automated: typing the month and year in one cell and ...
0
votes
0answers
28 views

SEARCH in a range of field , and decide to display / not display a value

I'm currently working on the following numbers document If there is no BTW-Code 1 or 2 in the right column , I don't want the line to be displayed in the summary. Is there a way to achieve this in ...
1
vote
1answer
112 views

How to do multiple conditions in one formula; and/or use a string as a condition?

I’m trying to make a formula that does different things under different conditions in different cells. What I have is: IF(BM16=−1,1,"O") This produces the letter ‘O’ for open in my case. What I ...
0
votes
1answer
45 views

fixed date in numbers template

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 ...
1
vote
1answer
124 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 ...
0
votes
0answers
85 views

Sync Numbers templates between OS X Yosemite and iOS 8

I want to create a template spreadsheet in Numbers for OS X Yosemite and have this template appear in Numbers in iOS 8. I've followed the advice in this page and have created a template on my Mac. ...
0
votes
1answer
78 views

Numbers: is it possible to add multiple select elements?

I'm working on template in Numbers. Some cell in template can have only specific values from code lists, so I decided to add pop-up format for them. But some cell can have multiple values from code ...
1
vote
2answers
2k views

How do I separate multiple comma separated values in Numbers

So, one of the CSV files I'm using has lumped the address into one single cell, separated by commas. For example: 12 Fairy Tale Lane, Wonderland, Oz, Neverland I need to separate these into Address ...
0
votes
1answer
113 views

How do you formulate Microsoft Excel “if” statement equivalent in Numbers?

The syntax of a simple Excel if statement is: =IF(a1="a",b2,"") This places the contents of cell b2 in the current cell if cell a1 contains the character "a". Otherwise the current cell is cleared. ...
0
votes
2answers
115 views

Apple Numbers program, weird thing with unix time code formula

Hi I have applied the unix time code formula =(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24) And it works! But the result I get on my column only shows the date and not the time. Does anyone know how to ...
0
votes
0answers
16 views

Problem with Numbers, stopped working!

The Numbers Icon on my IPad suddenly greyed out. When I selected it it went in to waiting state. Eventually it tried to load but gets to a certain stage of loading and hangs. I have some important ...
2
votes
0answers
271 views

Do Pages, Numbers and Keynote for Mac/iOS offer real-time collaboration on shared documents like Pages, Numbers and Keynote for iCloud do?

In Pages and Numbers (I guess Keynote too) for iCloud if you share a document and then send the link to other people you get real-time collaboration between the contributors as they edit the document ...
0
votes
0answers
85 views

Numbers: Replace URL with image

Is there any way to replace a text field cell which contains a URL with the image which that URL points to? It would make my life so much easier.
1
vote
1answer
151 views

Get cell value by address string in Numbers

In Numbers 3.5.2 I manage to get a cell address sting (I compute it based on some data). Now when I have it, how can I get the value behind that address without copying the result of my function to ...
0
votes
0answers
21 views

Numbers spreadsheet - list of worksheets on right side

How can I get a menu of the worksheets on the right side of a Numbers workbook? In an older Numbers version, the default was to have a list on the right so you could scroll down to find the worksheet ...
0
votes
0answers
89 views

When does Numbers sync spreadsheets?

In Numbers, connected to wifi (good bandwidth), after modifying a spreadsheet I go back to "Spreadsheets". Then I wait for the Arrow ↑ to appear, as it indicates that Numbers is syncing with iCloud. ...
0
votes
0answers
199 views

Cross-reference data from different tables in Apple Numbers

I have a table with exchange rates, and a table with business costs made in various currencies (Yen and USD). I have a column that lists the exchange rate on that day to make the calculation back to ...
1
vote
2answers
92 views

Numbers default colors

The default grays in Numbers don't suit my needs (the gray is too dark). Is there any way to adjust this pallette? I always find myself diving into the colors palette but this gets time consuming and ...
2
votes
0answers
43 views

Looking for a grandma-safe way to create two-fold greeting cards

My Mom (+ 70) longs for the day when her Windows Paint Shop program would walk her through creating a 2-fold 8 1/2 x 11 card. She could assemble the card one page at a time and not think about what ...
0
votes
0answers
386 views

Why can't I edit a Numbers spreadsheet I created?

I have a small spreadsheet I created in Numbers. But when I click in the spreadsheet, there is no cursor and I can't edit anything. Could anyone tell me why this might be? Numbers 3.5.2 MacBook Air ...
0
votes
0answers
98 views

How to use Numbers to generate pdf on a web server and then email it out?

I have an issue. My client loved the report I generated using Numbers on Mavericks OS X. The bad news is that the data is being processed on a ubuntu machine running python and django. I want to ...
0
votes
0answers
43 views

Export specefic iTunes music information to spreadsheet?

Ok so I really need help with this one. I'm doing a school project and I need to be able to chart the Date Added, Date Last Played, and # of plays. Does anyone know of a way to export/copy/retrieve ...
0
votes
1answer
115 views

Numbers - date cell set to last day of the month

I have a Numbers sheet that I use to forecast the monthly interest payments on my mortgage and it's working well. The only issue is that the date cells auto-sets to the first day of the month. Is ...
0
votes
2answers
249 views

Numbers: VALUE function does not recognize empty string

I am using Apple Numbers and find it frustrating that cell arguments containing empty text (and sometimes contain numbers from other sheets) are not converted to a number of value 0, when referenced ...
0
votes
1answer
142 views

How to convert to millions in Mac:Numbers?

I understand in Microsoft Excel you would use the format string $#.##,," M" so that 12,271,359 would appear as 12.27M I am alittle confused with the Numbers app on Mac (the excel equivalent) and I ...
0
votes
0answers
163 views

Numbers.app - How to add up items from multiple sheets and popup lists

Based on the "Personal Budget" template: I want to use the Personal Budget template and modify it to my needs — I want a total sheet that will add up information from 12 data sheets (for each month). ...
0
votes
1answer
828 views

Creating an adding and subtracting formula in Numbers

I'm creating a financial spreadsheet and need to ask the spreadsheet to calculate the new balance after subtracting and adding sums. For example, I want to calculate the running total in E column. I ...
2
votes
1answer
1k views

Greyed out Hide Column command

In iWork Numbers, why is the command Hide Column greyed out? What format do I have set up that does not allow me to hide that specific column? I have un-merged all the cells.
1
vote
1answer
29 views

How to mark some columns as ignored for calculations Numbers?

I'm creating a template on Numbers and I would like to know if there is a way for the formula to ignore, or skip over some cells or even entire columns. I need these columns for some calculations, but ...