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

learn more… | top users | synonyms

0
votes
0answers
24 views

How can I change the behavior of alt-return and return in Numbers 3.6?

According to https://discussions.apple.com/thread/2448952?start=0&tstart=0, there's a box at the bottom of the table inspector: There are at least two ways to make multiple lines in a cell. ...
1
vote
0answers
256 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 ...
0
votes
0answers
46 views

Highlighting Cells in Numbers (but the highlights not show up when printing)

I have Numbers Version 3.6.1 on a MacBook Pro. I'm wondering if it's possible to have a cell highlighted/coloured in (denoting it is supposed to be edited) but have it not print highlighted? I see ...
0
votes
0answers
13 views

Generate the averaged color for the cell based on a range of other colored cells

I have a range of cells, each one is colored in yellow, green or red. I want to have a "total" cell, that shows me "averaged" color. Here is how my table looks like: Is that possible to do with ...
0
votes
1answer
39 views

Is there a way to import stopwatch data into Numbers?

I use the stopwatch app to collect data sometimes, and often I'll have ~100 datapoints. (as an example, my light creaks periodically after I turn it off after leaving it on for a long time, so I timed ...
1
vote
1answer
156 views

Numbers How to show a hidden column?

First time working with Numbers and I hid a column by mistake. How do I show/unhide a column in this application?
0
votes
1answer
14 views

Is it possible to add an HTML Snippet to Numbers on OS X?

Is it possible to add an HTML Snippet to Numbers on OS X? I would like to add some html code and have Numbers treat it as such, for example to use iframes embed websites into my document. Would this ...
0
votes
1answer
63 views

In Numbers, is there a way to get the row instead of the value when using a MAX or MIN Function?

In Numbers, is there a way to get the row instead of the value when using a MAX or MIN Function? For example, let's take this sheet: bread 10 cheese 20 meat 35 What I am trying to do is to show ...
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 ...
0
votes
1answer
40 views

Why doesn't Numbers remember my last cell position?

For latest release of Numbers for iPad, it seems that it doesn't remember the active cell when I close the spreadsheet. I have spreadsheets with many (several hundred) rows and in previous releases, ...
1
vote
1answer
42 views

Exact string matches considering Case with COUNTIF

=COUNTIF(B1:B7; "US") counts anything with US us Us uS anywhere in the cell B1:B7 How to count ONLY exact matches to "US" accounting for case? (only that string, only capitalized)
-2
votes
1answer
37 views

Calculating volume which formula in Numbers?

We are tracking the water depth of our cistern and would like to input the volume of water as a function. We have the measurements of the cistern so the only changing variable is the depth. Which ...
0
votes
1answer
24 views

Table Formating in Numbers 3.0

In Numbers 3.0 is there a means to have a dark or heavier line every (5) lines for both the columns across and rows down?
0
votes
0answers
20 views

Getting values from separate spreadsheet file in Numbers

I have two separate spreadsheets that one contains the daily business activity and the other that contains a monthly business accounting reports. Is there a formula to get my data from my daily ...
0
votes
1answer
195 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 ...
0
votes
0answers
42 views

Apple Numbers: how to change the currency format for all tabs

I have some documents on Apple numbers where each page has different contents. On one of the fields I have a currency field and different formats (Custom Format 1... Custom format 37), it changes ...
2
votes
0answers
105 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 ...
0
votes
0answers
37 views

Apple Numbers 3.5.3 VLOOKUP Help

I'm trying to compare two columns of zip codes in Numbers via VLOOKUP and can't for the life of me figure out how this thing works. I need to find out if a zip code in Table 1 Cell E2 appears in ...
0
votes
0answers
101 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 ...
0
votes
1answer
66 views

In Numbers, how can I sum only if adjacent cell is certain value? [duplicate]

In excel, as shown here, it is possible to find and sum only cells with have a specific value next to them. Is there a way to do a similar thing in numbers? Specifically, I have a very long table ...
1
vote
1answer
316 views

Automating numbers, Exporting the file as an excel document

I have recently acquired a Macbook Pro (OS X Yosemite 10.10.4). I find the Numbers application satisfactory to work with, but I save the file as an .xlsx file after I am done. I need to make changes ...
1
vote
3answers
50 views

.xls file attachments in Gmail opens, by default, with Numbers

I am using latest version of OS X, whenever I want to download an .xls file from email attachment, it opens, by default, with Numbers and the file is not downloaded on my machine. How can I change ...
0
votes
0answers
10 views

Preserve calculated total in filtered view

I entered filter mode inside a table within numbers.app and then used formulas to add and subtract cell number data from various cells. I would like to be able to hit a button that would take that ...
1
vote
1answer
28 views

Numbers: Line graphs for cell values across multiple worksheets

I want to create a line graph whose reference data is across multiple worksheets. For example: I have 5 different worksheets (named W1 to W5) In each of the worksheet, a specific cell (Ex: B2) in a ...
2
votes
1answer
60 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
22 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
159 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
74 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
34 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
162 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
102 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
331 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
59 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
112 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
123 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
241 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
48 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
13 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
332 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
92 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
294 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
38 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
132 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
24 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
237 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
275 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
30 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
158 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
47 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
168 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 ...