# Questions tagged [numbers]

Apple Numbers is an application for creating spreadsheets and graphs. Use this tag for all versions of this app, web based, iPad and iPhone as well as macOS

708 questions
Filter by
Sorted by
Tagged with
110 views

### Severe problems with all .numbers files that are on iCloud + shared to other people (everyone with link / read only)

Business user here. I didn’t get an answer at discussions@apple so now I am here. I use iCloud for my law office, every client folder has its own Numbers file so it’s at least hundreds of .numbers ...
• 31
1 vote
24 views

### Capture higher degree trend coefficients on iPad Numbers app?

I see there’s a way to capture slope and intercept for a linear trend according to Numbers.app Chart Trendline Equation Capture and its answers, but I’m using a polynomial trend in Numbers on an iPad ...
48 views

### In Numbers, what determines ascending order?

In Numbers app, ascending order ranks a cell containing “A + B” before “A.” But I would like it to be ordered thus: “A,” “A + B,” “A + B + C,” “B,” “B + X,” etc. I could switch to descending order, ...
• 131
8 views

### Numbers: Copy table to another sheet keeping local references

I need to copy a table from one sheet to another but keeping the local reference. The scenario is like this: Sheet1 Table1 Item Price it_1 10.00 it_2 15.00 ... ... Table2 Summary =SUM(Table1::...
1 vote
15 views

### What formula will count the number of words in a cell, ignoring dashes and other standalone punctuation?

I need to count the words in each cell of a table. There’s no built-in wordcount function, so I’ve previously used a couple of methods that effectively count the number of spaces, adding 1 to get the ...
137 views

### Can't get Numbers to sum up percentages correctly

I have a column with percentages; example: 8.3% 8.3% 8.3% 25% 25% 12.5% 12.5% It should sum up to 99.99%, but Numbers produces a result of 0.75 for me, Any ideas what's going on and how to fix?
• 1,039
1 vote
18 views

### No proxy icon in macOS Numbers app window?

Seems to be no proxy icon in the title bar of the Numbers app (13.2) in macOS 13.6.5 -- the icon you can use to drag/drop the file. Am I just overlooking it?
• 55
1 vote
194 views

### Schengen 180 day calculator works in Excel, not in Apple Numbers

I have an excel spreadsheet I created on Windows for a friend to caculate how many days someone has spent in the EU's Schengen area over any 180 day period (I've shown an image from it below). It ...
• 111
50 views

### extracting cell contents using Numbers

I have a Number's file. Each row has details for a different person. One of the columns is their email address. How can I extract these addresses and put them in a simple, unformatted text file - ...
• 331
83 views

### Editing one column of table based off another

It seems like something that should be simple, and it probably is but my mind is being dense and not helping me. I have a table with two columns. The first acts as a master list of titles, and the ...
178 views

### How are password protected Numbers files encrypted?

Does anybody know the security details behind password-protected spreadsheets in Numbers? I've checked the documentation on Apple.com, but it's not exactly flush with technical details. From Password-...
• 53
1 vote
18 views

### How to control what happens when I tab or enter or return in a cell?

I'm adding data to a sheet on macOS. There are exactly 4 columns. Ideally when I'm done with a line and hit tab or return, it'd go the the next row at the start of the line. It seems like I've had it ...
• 318
14 views

### Numbers XLOOKUP-like, but for specific rows?

I have a simple table in Numbers that has one numeric entry per day, over a period covering about two years. Basically, B C 1 Date Reading 2 2022-03-01 3515 3 2022-...
• 2,256
1 vote
46 views

### Create top ten in Numbers

I have a table in Numbers that counts the number of times certain text appears in other tables. It looks like this: Día Cantidad 1 de enero 0 2 de enero 1 3 de enero 3 4 de enero 1 5 de enero 1 ...
• 111
135 views

### Wrong number calls to my business from Siri

For the last 4 months we have been receiving at least five wrong number calls every single day. All calls are coming through one particular number even though we have four numbers on our website. ...
1 vote
41 views

### What does Order in iWork Number's graph inspector mean?

What does Order in this screen shot, from Numbers, do/mean? I searched the help for Order but couldn't find anything.
• 3,418
1 vote
421 views

### Create a frequency chart in Numbers?

I am trying to create "frequency chart" in Numbers, and found this this thread but I don't understand the suggested formula: =INDEX(FREQUENCY(Data :: A, A), ROW()-1) Why the double colons ...
• 3,418
99 views

### Numbers: why are references to a pivot table preserved (i.e., \$)?

I have a pivot table on sheet 1 and try to make another table with data from the pivot table on sheet 2 (because you can't add columns to a pivot table, can you?). However, if I write a formula like ...
• 3,418
80 views

### Can I change or set the default Import Settings for pasting text lists in Numbers?

When I paste a list with small sentences in Numbers the default Import Settings is "Fixed Width" and the lines are distributed in several columns while I would like them to be pasted in a ...
• 101
99 views

### Apple Numbers - How to simplify this formula

I have a spreadsheet with Date, Amount, and Description from my Bank. I try to make it categorize automatically the stores I visit most often, so I don't have to do this manually. In column Store, I ...
• 239
13 views

### "Floating" image in iWork Numbers?

Is it possible to make an image "float" in Numbers? That is, similar to how the heading row can remain visible ("float", "freeze pane" in Excel lingo) when scrolling down ...
• 3,418
48 views

### How do you make the x-value of a Numbers graph start with a number that is not 0 -- repeat question, but for 2d bar chart

the question was already asked, with a great response, BUT I'm trying to use a 2d bar chart, and the Scale Max / Min is locked with 'auto' QUESTION & ANSWER
1 vote
507 views

### Convert a string of numeric calculations to numeric value in Numbers

I have a string of a numeric calculation in one cell. The input for the cell is ="1+2+3". So the cell is displayed like this: Column A 1+2+3 How can I get the numeric outcome of the ...
• 21
1 vote
233 views

### How to get quotes for certain currency pairs into Numbers using a function

The pictures don't show the ⚠️ for errors but each blank cell is an error that reads something like: There is no historical data on the requested date. The next available is on 8/7/2827673. The ...
• 175
1 vote
42 views

### Need Help With Formula For Rent Ledger

I have a rent ledger sheet that lists all the rent due dates (Column A) and amounts (Columns B & C) both past and future as shown below. Each month there are two payments due, Column B is due on ...
46 views

### Trouble creating line graph on numbers with multiple variables

I have little to no knowledge when it comes to Numbers/other data programmes. I’m working with a client and I want to create a line graph to show how these variables affect each other (eg. Does food ...
103 views

### How to convert any duration to days in Numbers?

I have something like this Start time (A) End time (B) Time passed (C) Units done (D) How many units per 24h (E) 08:25 15:40 7h15m 43 ??? I can manually calculate that 7h15m = 26 100 seconds. 26 ...
• 3,418
312 views

### Problem using Numbers Regex.Extract function

I need help with the following Apple Numbers REGEX.EXTRACT formula that doesn’t return the word before a dot. Below are the text form of the arguments passed to the formula and the formula itself as ...
• 21
211 views

### Opening older Numbers files

I am running Monterey, with Numbers version 11.2. I have some old spreadsheets that I created in Numbers circa 2011. I tried to open them and received the error message: "[filename].numbers can't ...
136 views

### my numbers spreadsheet is all screwed up and I can't figure out why or how to fix it

It is as if my spreadsheet is overlapping itself... What is going on?! how do I fix this?
• 435
1 vote
2k views

### Basic use of SUMIF in Numbers app?

How does one write a simple SUMIF formula in Apple Numbers app, version 13? For example… In this example, I want to write two SUMIF formulas in two cells: The sum of numbers in the entire second ...
• 12.9k
1 vote
30 views

### Cmd+x halting the OSX keyboard

I have run into a very weird problem and any insight into this would be much appreciated. I noticed for the past two days whenever I press the cmd + x keys into the keyboard to cut an entry in the ...
• 51
52 views

### To sort a table with linked data

There is a Numbers document with 3 sheets: first (2 columns), second (1 column), and third (1 column). second: sun grass sea third: yellow green blue first: Column A | Column B =second::...
692 views

### Opening CSV in Numbers does not display decimal numbers correctly

Lets say I have following CSV file: 1.0;0.125;0.1253 Opening it in Numbers gives me: Why are 1.0 and 0.1253 correctly presented as "1.0" and "0.1253", but "0.125" is ...
• 181
1 vote
83 views

### Formatting Numbers conditions for SUMIFS

I have a SUMIFS that gets the desired result. But the condition is formatted as a string, in this case a date comparison, "<=2023-03-21". The date is located in cell B2. How can I rewrite ...
• 2,256
38 views

### What template on numbers spreadsheet is suitable for the following need?

Using Numbers spreadsheet on iPhone, what template is suitable for the following need? I want to follow the gaps between events occurring once a month on different dates, after inserting them into the ...
2k views

### How do I get Dark Mode on Apple's Numbers

How do you get Numbers to be in Dark Mode. (The OS itself is in Dark Mode) You can change the background of the spreadsheet buy use of Format Text But how do you get the surrounds to be white on black ...
• 30.4k
369 views

### Numbers: Get max value and the value's date

I have a document where one column is a date and another is a value for the date. I'd like to be able to get the maximum value and the date when that value appeared. For example if I had A (Date) B (...
• 2,256
106 views

### Timestamps in Numbers are only partially recognized as time?

I have a column with timestamps minutes, seconds and milliseconds. Originally they looked like this 6:24,120 (it is output from the time command) Pasting it into Numbers causes weird results. I can ...
• 3,418
1 vote
66 views

### How to move an equation in a diagram in iWork Numbers?

I have a diagram in macOS Numbers 12.2.1 with two trendlines where I also inserted the equation for each trendline. The problem is that those two equations are on top of each other and I can't find a ...
• 3,418
1 vote
145 views

### Font size in Apple Numbers, Excel and LibreOffice Calc

See the screenshot below. The same font & size with zoom level 100% has different visual sizes in these three macOS spreadsheet apps: Apple Numbers v12.2 (left) Microsoft Excel for Mac v16.69.1 (...
• 111
119 views

### How to add up multiple values per row in Numbers using SUMIF?

I would like to use a formula to add the values from columns B,C and D for all rows where checkbox A is set. In this example, this would be 1+5+9+3+7+11 = 36. Unfortunately, my attempts like SUMIF(A;...
• 103
1 vote
54 views

### Is it possible to have multiple values in a cell

I have a Column called "Genre" where it should be different TV show genres, but as you all might know these could be multiple. Like Drama, Comedy and so forth. When filtering for Comedy I ...
• 11
580 views

### Trying to catalog my movie collection into Numbers app and "48 hours" becomes "2d"

I can type into a cell "40 year old virgin" but I can't put in "48 hours" as it gets changed to "2d". What nonsensical setting is making this happen? Also if I type in &...
• 435
1 vote
41 views

### Numbers Mac Link Date Cells

I would like to link cells formatted as dates together so that I can change the date in one cell and have all the dates change to go in order from that date. So if I format the cells to go from Jan 1 ...
1 vote
776 views

### Numbers.app Pop-Up Menu from Column?

I need to automate the following somehow, and I want to know if it's something that the software can accomplish: I need to set a field in a table to a Pop-Up Menu, that is made up of entries in a ...
• 263
1 vote
43 views

### How do I stick a graphic to a frozen header column in Apple Numbers?

I want to paste a graphic on a frozen header column, and have it frozen to the header column when I scroll the rest of the table. But when I paste the graphic over the frozen header column and scroll ...
• 631
1 vote
167 views

### Numbers not sorting names correctly

For some reason I’m having issues sorting column D. When I tap “Sort Ascending” it sorts everything correctly except books 5 and 7: “12, 13, 14, 15 16 17, 18, 22, 23, 5, 7” I’ve tried deleting all the ...
• 173