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
1
vote
1answer
44 views

Numbers 3.6: Change text depending on value

Newbie here! I'm trying to find a function so when I enter a value in one cell (A1) it gives me a predetermined word in another cell (A2). The values are ranges (0-19, 20-39, 40-59, 60-79 & 80<...
2
votes
1answer
2k views

Two value-based axis for chart in Numbers 3.5

I am trying to achieve a chart in Numbers 3.5 where both axis scale linearly. Right now, my chart looks like this: Obviously, I want the x-axis to scale because the 100.000 bytes message is MUCH ...
3
votes
2answers
2k 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 ...
1
vote
2answers
69 views

How to get total amount for each client in a list automatically?

Let's say I have a long list of clients in one column of a Numbers table, most of them occurring multiple times, and in the adjacent column are amounts due for services received, as depicted below. ...
0
votes
1answer
659 views

Numbers: How to make a sum product of 2 columns numbers of which only those with checkboxes checked in a 3rd column respectively?

Say, sumproduct(A, B)=a1*b1 + a2*b2 + a3*b3, now I have many columns C, D,..., e.g. c1 checked, c2 unchecked, c3 checked; d1 unchecked, d2 checked, d3 checked; Now I need a formulae which I want to ...
0
votes
2answers
149 views

How can one jump to a specific line in Numbers?

In Numbers on a MacBook Pro Early 2013, how can one jump to a specific line, such as line 4223860. The data is actually csv formatted, and I have no clue what is inside that line. Any help is very ...
1
vote
1answer
4k views

macOS Sierra / Numbers 4.0: Problem with saving on a Synology via AFP

I updated my Mac to 10.12 Sierra and updated Pages, Numbers and Keynote afterwards to the latest versions. So far so good, everything running normal. But unfortunately saving a Numbers file via AFP ...
0
votes
1answer
2k views

Keynote, numbers and pages not available on El Capitan after reinstalling

I had installed Windows on my MacBook Air after wiping its HDD and then decided to have OS X reinstalled. One thing I noticed is that the office software that had previously showed up in the dock wasn'...
1
vote
1answer
73 views

How to find all iWork documents which are not yet converted to iWork'13?

When opening documents in iWork'13, the documents are converted and may wind up looking different if they were created in iWork'09 (see Apple support article ”Working with iWork'09 files"). Documents ...
5
votes
1answer
22k 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 ...
4
votes
1answer
7k views

exporting numbers 09 to excel with photos in spreadsheet

When I export my numbers spreadsheet with photos in the column the photos do not transfer when I import it into excel. How can I do this?
2
votes
1answer
1k views

Mass conversion of .numbers files to .csv

I have a lot of files with a .numbers file extension, and I need to convert them to .csv, so I can more easily work with the data. There are probably about 1000 of them, so opening them in numbers and ...
2
votes
1answer
46 views

Format values in text cell

I have a chart with two percentage columns (min, max), and a third which is supposed to show the min-max range in absolute values. I use the formula =A2*60&" - "&B2*60 in cell C2. The expected ...
0
votes
1answer
23 views

Displaying numbers with the right sign

I have an odd question: how can I persuade Numbers to show the signs of a series of numbers which may be either positive or negative? The negative sign is a default setting, but there appears to be no ...
0
votes
1answer
7k views

Conditional IF DATE function

I am working to create a function that keeps the data in a cell dynamic until the date is beyond that of the date column. In other words, there is a column of dates, i.e. 9/5 9/6 9/7... and the other ...
4
votes
1answer
3k 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 (and ideally also highlight) each point with the corresponding entries ...
0
votes
0answers
37 views

Copy contents of Numbers file on OS X El Capitan

When I ran OS X Yosemite, I worked on a .numbers file. Just recently, I needed to acces the contents of that file. However, the file opens only in Preview, and the Numbers app appears to be a paid one....
0
votes
2answers
5k views

Mac Numbers - How do I add up cells containing data (text) per column

In my Mac Numbers Spreadsheet, I have got a column containing a product title. I would like to add up the cells containing a title at the bottom on my spreadsheet. What formula do I use for that? ...
1
vote
1answer
274 views

Numbers: Count number of payments, SumIf, CountIf, Concatenate Date, change data types

I am trying to create a spreadsheet that will figure out how much has been paid to date, from a list of payments in a separate row. I have tried many different options including using SumIF and ...
0
votes
2answers
67 views

Where has Numbers gone?

I created several spreadsheets in Numbers. Lately I have been using Excel, which won't open them. I can't find Numbers in my application folder--is it hiding somewhere??
5
votes
2answers
18k views

How to display zero value as blank cell in mac numbers 3.1

How do I display zero value as blank cell in mac numbers 3.1 yet maintain a formula. I want a running balance column that only shows balance to the line of the last entry like a checkbook register. ...
3
votes
8answers
19k views

Is it possible to remove cell borders from Numbers?

I imported an Excel spreadsheet that contained a few cells with black lines as their border. Is it possible to remove these outlines through Numbers (iOS)? I have tried copying and pasting, the ...
3
votes
1answer
5k views

Numbers: checking if cell with specific text exists

Prerequisites I have some tables with cells like so: Also, I have some more tables like so: Objective Note the YES and NO. in the Included column in the Example Requirements table. You will note ...
1
vote
0answers
55 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 ...
2
votes
0answers
303 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
1answer
968 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 ...
2
votes
1answer
942 views

How to get rid of default font (Helvetica Neue) in Numbers?

I am using Numbers '09. I defined (and saved within My Templates) a template of a very basic table format where all cells are formatted with Palatino: If I simply hit ⌘+Xwithin any selected cell, ...
0
votes
1answer
34 views

How do I save the Numbers document I'm working on?

Using Numbers 3.6.2, and would like to save document to finish later. Where do I save it? (Saving to PDF is permanent)
1
vote
1answer
55 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") I'm trying to generate an if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 if over 90. I have been trying the above however ...
0
votes
1answer
282 views

Can Numbers use 8 hour long days when converting from days to hours?

Using Numbers 3.6.2, I am using cells formatted as "Duration" in days. I then have a SUM cell that sums all the durations and shows for example "64d" (Suppose in cell D1). I then do in a new cell (D2 ...
0
votes
1answer
3k views

Numbers SUMIF by dates within current week?

I have a table like this: Which basically contains jobs I've done, the dates I did those jobs and how much that job made me. I'd like to find out how much money I've made this week (current date is ...
0
votes
2answers
1k views

How do I fix a file that crashes Numbers?

A long time ago, I made a relatively simple Numbers document with some tables containing text and images. It lives in iCloud, and I can preview it using Quick Look. But now when I try to open it, ...
3
votes
4answers
6k views

Connecting MySQL DB to Apple iWork Numbers?

I'd like to visualize some data from a MySQL database using a Mac, but it hasn't been easy finding a solution to this. I understand Excel has DB connectivity, but currently I only have Apple Numbers. ...
0
votes
1answer
67 views

How can I make two cells edit and display the same information in Numbers?

I would like two cells to contain the same information, if I modify one the other should modify also. I was using the Concatenate function to make "slave" cells that pull data from a "source" cell ...
0
votes
1answer
105 views

How to calculate a date field in Numbers

I'm using a date field as a conditional element. If cell A1 which is date field is empty (no date has been entered yet), then leave the cell A2 blank. If there is a date entered into A1, run a ...
2
votes
0answers
492 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....
1
vote
1answer
88 views

Numbers: Force a calculation

My apologies for such a basic question, but I have searched for many hours to no avail. I have a very simple spreadsheet with two columns of data. In the third column, I write a formula such that ...
0
votes
0answers
57 views

Two formulas in the same cell in Apple's Numbers

In Apple's Numbers, I have a table which calculates GAP between two values in two rows (red), I would like even to calculate gap between calculated values in the same cell (blue), is it possible?
0
votes
1answer
417 views

iCloud numbers reference date/value from another table

I am trying to create a daily budget tracker with separate tables for each month, which I have created. I now want a front/first table to show: the balance as at today's date the amount spent today (...
3
votes
4answers
925 views

What causes all iWork apps to have blank, unusable documents after a reinstall?

After deleting and re-installing the apps, I can't use iWork. Specifically, the document area is always empty, no matter if I create a new document or open an existing one. This applies to Pages, ...
17
votes
2answers
32k views

Numbers: Count unique items in a column

I'd like to count the occurrence of unique items found in one column of about 120 items. I can't find a way to do this in Numbers.app
1
vote
1answer
607 views

Tan-1 on Numbers

Is there a way to do tan-1 using numbers on El Capitan to return an angle? I have two lengths 1.5 and 2.2 for example. I can do it on a scientific calculator but not on numbers.
0
votes
1answer
46 views

On Pages, inserting a graph from Numbers gives a black line at the bottom

Notice the black line at the bottom of the graph. When I add another graph after it (its inline), the line moves to the bottom of the next graph so that there is only ever 1 line.
1
vote
1answer
68 views

Can I create a formula to provide a value depending on when a timestamp falls in the day?

In column A, I have timestamp values. In a second column, I'd like to have a formula that would return words or strings like "early morning" or "Late afternoon", so that I may count and chart these ...
3
votes
2answers
2k views

Numbers: Make numbers negative

In Numbers, how can I convert a number to negative. E.g. 200 233 186 Becomes -200 -233 -186 In Excel, you can use tools like Paste Special, but these don't exist in Numbers.
2
votes
2answers
1k views

The SUM function in Numbers 3.6.1 on my Mac OS X10.10.5 isn't calculating correctly. Why?

You can see in the attached screenshot that I have used the SUM function to add the values in column E. There are several "1" values (you can see one in cell E126) but the SUM always comes out at "0". ...
1
vote
1answer
47 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 ...
0
votes
2answers
736 views

Style text in Numbers formula

I have a numbers formula used in invoice generation: ="Invoice terms: "&CONCATENATE(Terms)&", please pay by ..." Which returns: Invoice terms: 14 days, please pay by ... Is there a way ...
1
vote
2answers
10k views

I've just updated my Mac to Yosemite and now I can't open a .numbers file

I have just updated my Mac to Yosemite and after that when I try to open .numbers file, I couldn't, and it gives me this message "edit 1.numbers can't be opened". I do not know why and I really need ...
2
votes
1answer
518 views

How to type floating point numbers in Apple Numbers in Persian?

When I want to insert a floating number in Apple Numbers 3.6.1 in OS X 10.10.5 while my primary preferred language in Language & Region is Persian(فارسی), the number is interpreted as a string ...

1
6 7
8
9 10
12