Skip to main content

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

Filter by
Sorted by
Tagged with
3 votes
1 answer
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 ...
H A's user avatar
  • 31
1 vote
0 answers
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 ...
ProfInsall's user avatar
0 votes
0 answers
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, ...
h_undatus's user avatar
  • 131
0 votes
0 answers
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::...
Alvaro Pedraza's user avatar
1 vote
1 answer
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 ...
Guybrush McKenzie's user avatar
2 votes
1 answer
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?
daisy's user avatar
  • 1,039
1 vote
0 answers
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?
macsci's user avatar
  • 55
1 vote
0 answers
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 ...
PedroKTFC's user avatar
  • 111
0 votes
1 answer
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 - ...
Dan's user avatar
  • 331
2 votes
1 answer
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 ...
user717452's user avatar
0 votes
0 answers
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-...
fyrekcaz's user avatar
1 vote
0 answers
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 ...
Hack Saw's user avatar
  • 318
0 votes
0 answers
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-...
Tom Harrington's user avatar
1 vote
0 answers
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 ...
jesusjimsa's user avatar
0 votes
0 answers
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. ...
ComputerHouseCall 's user avatar
1 vote
1 answer
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.
d-b's user avatar
  • 3,418
1 vote
1 answer
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 ...
d-b's user avatar
  • 3,418
0 votes
1 answer
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 ...
d-b's user avatar
  • 3,418
0 votes
0 answers
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 ...
pok_net's user avatar
  • 101
2 votes
1 answer
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 ...
user14119170's user avatar
0 votes
0 answers
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 ...
d-b's user avatar
  • 3,418
0 votes
1 answer
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
Nicole Martin's user avatar
1 vote
2 answers
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 ...
Philea's user avatar
  • 21
1 vote
1 answer
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 ...
yarns's user avatar
  • 175
1 vote
1 answer
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 ...
macuseronline's user avatar
0 votes
1 answer
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 ...
Isobel Rose's user avatar
0 votes
1 answer
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 ...
d-b's user avatar
  • 3,418
2 votes
2 answers
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 ...
SIT123's user avatar
  • 21
0 votes
0 answers
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 ...
Displaced Hoser's user avatar
0 votes
1 answer
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?
patrick's user avatar
  • 435
1 vote
1 answer
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 ...
Basil Bourque's user avatar
1 vote
0 answers
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 ...
Ramit's user avatar
  • 51
0 votes
1 answer
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::...
user avatar
3 votes
1 answer
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 ...
kostrykin's user avatar
  • 181
1 vote
1 answer
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 ...
Tom Harrington's user avatar
0 votes
0 answers
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 ...
Ubiquitous Student's user avatar
7 votes
1 answer
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 ...
mmmmmm's user avatar
  • 30.4k
0 votes
1 answer
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 (...
Tom Harrington's user avatar
0 votes
0 answers
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 ...
d-b's user avatar
  • 3,418
1 vote
0 answers
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 ...
d-b's user avatar
  • 3,418
1 vote
0 answers
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 (...
haba713's user avatar
  • 111
0 votes
1 answer
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;...
Ben's user avatar
  • 103
1 vote
1 answer
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 ...
Triphys's user avatar
  • 11
2 votes
1 answer
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 &...
patrick's user avatar
  • 435
1 vote
1 answer
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 ...
LadyAG5483's user avatar
1 vote
0 answers
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 ...
Rich_F's user avatar
  • 263
1 vote
0 answers
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 ...
Jan Steinman's user avatar
1 vote
1 answer
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 ...
Morgan's user avatar
  • 173
2 votes
1 answer
912 views

How to have Numbers automatically sort descending?

I’m trying to make my own Sports latter in iPadOS Numbers. I have noticed that there’s an option to sort cells by ascending or descending but I have to click on that option every time I want to update ...
Morgan's user avatar
  • 173
0 votes
0 answers
1k views

Numbers: Combine several tables into one

I have a Numbers spreadsheet with a table for each room in our house listing jobs that need doing and a priority rating for each. For example: Kitchen Job Priority Fix tap ...
somnolentsurfer's user avatar

1
2 3 4 5
15