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
0answers
1k 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 ...
3
votes
0answers
417 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 ...
3
votes
0answers
2k views

How do I create a Pivot Table in Numbers 3.2?

I'm new to Numbers and currently using Numbers 3.2. I already have an idea of how to use SUMIFS to create Pivot Tables in Numbers, but I'm still looking for a better way to generate the column & ...
3
votes
0answers
354 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 ...
2
votes
0answers
38 views

Apple Numbers Query - Conditional Formatting

I am working on a numbers Spreadsheet that compares dates in cells. I am trying to create a condition where a date cell will turn green when the date is 3 months or more later than another date cell i....
2
votes
0answers
113 views

“Glitched” pixels, El Capitan, formula box in numbers

Today I installed El Capitan on my Macbook Pro and noticed some weird graphical effects when I was editing my numbers document: I know that this is entirely software-related, otherwise the screen ...
2
votes
0answers
134 views

Numbers shortcut to select next non-empty cell

I have just purchased my first Mac and am having problems with Numbers. I want to select the next cell in a given direction that is non-empty (or jump to the end of a contiguous chunk of cells that ...
2
votes
0answers
273 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 ...
2
votes
0answers
354 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 ...
2
votes
0answers
52 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 ...
2
votes
0answers
561 views

batch convert iWork 08 files to new version on Yosemite

TL;DR Short version: I have a bunch of files that were created with iWork 08. Is there a way, maybe using AppleScript or Automator, to convert them to the new format (Pages 5.5, Numbers 3.5) without ...
2
votes
0answers
328 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 ...
1
vote
0answers
17 views

Numbers formula for calculating *part-time* workdays per month?

I want to calculate the total number of monthly workdays for part-timers. Example, I need to calculate the full number of workdays in a month for a 3.5 day workweek, running from Tuesday to half ...
1
vote
0answers
17 views

Using date as x-axis

I wish to create a chart where you can compare how many awards a bunch companies have won over time. After collecting the data I now want to plot it in Numbers. To simplify I have put together some ...
1
vote
0answers
18 views

Can I create a Range in numbers

I am using Javascript for Automation (JXA) with Numbers.app and I am wondering if I can instantiate a Range object, i.e. define which rows are concerned by the Range so that I can apply a function ...
1
vote
0answers
22 views

Make a line chart in Apple's Numbers using series of Numbers

I have a table in Apple's Numbers where I log a number every day: I want to do a line chart where every week is a line, so I can compare, every week, the trend for every day, week by week, but I ...
1
vote
0answers
41 views

Automate Safari form filling

I have a Numbers spreadsheet with lots of data (currently at 275 rows, 14 columns each). I need to submit this data to a web form, one row per form submission, each column going into a text box on ...
1
vote
0answers
415 views

The font Calibri is missing. Your text might look different with Pages, Numbers

My documents do not contain that font anywhere. But the iPad still complains about this. How can I remove completely these font from document? Is there a way to do this? Maybe there are special ...
1
vote
0answers
21 views

In Numbers.app, Is there any function to identify if another cell is a formula, or contains a specific function?

I have a cell in a row that is either a directly entered number, or a SUM() of some other cells. Is there any function I can use in a different cell to know if the value in the former cell was ...
1
vote
0answers
99 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 ...
1
vote
0answers
301 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
0answers
61 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
575 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. I'...
1
vote
0answers
294 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
73 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
51 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
82 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
281 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
115 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
50 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
44 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 ...
1
vote
0answers
223 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
127 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
5 views

What is the Numbers equivalent of Excel's “Solver”?

I'm a former Excel user and particularly of the "Solver Routine" I have found nothing of that nature in Numbers. Also is there an integration routine to find the area under curves?
0
votes
0answers
7 views

Scatter Plots in Numbers

Using Chart in Numbers how can I reverse the plot values on the X axis of a scatter plot? I have searched Numbers Help to no avail.
0
votes
0answers
4 views

Error when using Numbers CONVERT function. Invalid unit?

Using Numbers 3.6.2 I'm trying to convert some numbers (with Numbers) with the use of the CONVERT function, like so: Working: CONVERT(1, "m", "cm") Not Working: CONVERT(1, "d", "c") CONVERT(1, "...
0
votes
0answers
8 views

Numbers: How Can I Make Rows and Columns Smaller than 9 Points?

I am making a grid-like diagram (for table seats at a party) using a Numbers table. Some cells are considerable wide and hold the names of the guests. But I need to make some of the rows and columns ...
0
votes
0answers
7 views

How I label scatter plot points in Numbers?

I have a scatter plot in Numbers using one column of data from my table for X values and another for Y values and want to label each point with the corresponding entries in a third column. How do I do ...
0
votes
0answers
9 views

Numbers: thin the data going into a chart

I have a CSV file with just shy of 60,000 rows. It's a time series from a device. Numbers kind of chokes plotting a chart, even though I only want 2 columns from it. It makes one, but it beachballs ...
0
votes
0answers
28 views

How do I set the number of decimals in a Numbers cell using AppleScript?

I can set the format of a cell in a Numbers spreadsheet using: tell application "Numbers" activate tell document 1 tell active sheet set the selectedTable to ¬ ...
0
votes
0answers
10 views

Numbers graph how to get series in front of grid lines

I am making a graph in Numbers with logarithmic y-axis. I would like to have grid lines at 0.01, 0.1, 1 and 10. However, if I use the "main grid lines" function (in the tab "axis") it won't draw a ...
0
votes
0answers
27 views

Numbers, wish to convert Excel to Vcard to import to Contacts

I have a 250+ contact Excel file that I wish to, instead of doing it by hand, one row at a time, batch-convert into iCloud Contacts -ready Vcards. Anyone have any idea how to do this? I've seen lots ...
0
votes
0answers
22 views

Numbers Mac — Search for text in a cell based on a list or range

Here's what I'm trying to do: Basically, I want to automatically "categorize" items in Column A. I have a list of course titles in Column A. I want to search each cell to see if it contains a ...
0
votes
0answers
34 views

How do I refresh a Apple Numbers spreadsheet to reload formulas?

I have a csv file that I import to Numbers. The file contains formulas such as =HYPERLINK("http://www.google.com","url to google") The problem is that it does not parse my formula but instead ...
0
votes
0answers
20 views

Automatic email sent from numbers?

I'm currently working on a spread sheet using the APP Numbers. It would be useful if when a particular number is entered into a cell an email reminder is sent to a member of my team asking them to ...
0
votes
0answers
19 views

Cannot access to iCloud Numbers document, it shows alert dialog: “Versions of the spreadsheet are out of sync.”

My friend sent me the shared link of the iCloud Numbers spreadsheet. I could access the document without any problem via the browser for the first time. However, from the second time, the following ...
0
votes
0answers
21 views

I need to link a cell in numbers to a Pages document. HELP

I would like to link a cell in a numbers document to a document in pages. I am creating a meal plan and want the recipe to pop up when clicking on the item. Any suggestions welcome, including whether ...
0
votes
0answers
11 views

Why does Cut in Numbers remove the cell formatting?

In Numbers 3.6.1 cutting [CMD+X] one or more cells not only clears the text, but removes the cell formatting too. Is there a setting to disable this behaviour? My only workaround is to Copy [CMD+C] ...
0
votes
0answers
17 views

Auto sum of daily sales on a monthly range

Given a table of monthly sales where one row contains one sale but one date can have multiple rows as follow: Date Earnings 2016-04-12 USD 10.00 2016-04-12 USD 56.00 2016-04-12 ...
0
votes
0answers
12 views

Multiple condition or Regular Expression matching with conditional formatting in Numbers?

I'm useless without colors to help my brain, so Numbers' conditional formatting works well for me.. up to a point. I'm afraid I'm hitting up against Apple's wont fix complexity threshold, but oh well. ...