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

learn more… | top users | synonyms

1
vote
2answers
117 views

Nested IF statement in Numbers

I am working on a table to tabulate mileage costs for my small business. I have 3 destinations I go to on a regular basis. I would like the address to automatically populate in the C cell if the ...
0
votes
1answer
29 views

Display blank on formula error

I'm making a timesheet. I have =sum (A2-A1) but I have more than one task a day and not all times are used. The cells without time in them result in an error with the formula. Which, in turn, choses ...
1
vote
1answer
27 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
100 views

How to change y axis numbers in Numbers for mac to show as custom letters or words?

I'm new to Numbers and now creating my first chart. I tried to find what I was looking for on google but couldn't find anything. What I would like to do is change the numbers in the Y axis to show has ...
0
votes
0answers
71 views

Numbers for Mac : Sumifs formula

I have a problem with my sumifs formula. I am trying to get: I want to achiev this: Sum C5:C7 from all lists that contain word Teletnik and in the first list Formular you would get the result in C4 ...
2
votes
1answer
96 views

Round displayed value in Numbers for iOS to 2 decimals

Say I have the value 2.3638383 in a cell in Numbers for iOS (iPhone). Can I format the numbers so only 2 decimal places are shown (rounded to nearest decimal)? So 2.3638383 would be displayed as 2.36? ...
0
votes
2answers
87 views

Reinstalling Numbers on Mac OS X

Numbers was installed with a different Apple ID to mine (my bosses), so it won't let me update it (when it prompts for credentials, you can't overwrite the user name). I therefore need to reinstall it ...
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
324 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
51 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
44 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
212 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
76 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
43 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
48 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
40 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
22 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
233 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
43 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
107 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
39 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 ...
1
vote
0answers
113 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
72 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
365 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
58 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
30 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
65 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
190 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
83 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
35 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
207 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
114 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
369 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
63 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
127 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
142 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
255 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
50 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
407 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
95 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
340 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
143 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.