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
1answer
92 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
60 views

Numbers for Mac : Sumifs formula

I have problem with my sumifs formula. I am trying to get enter image description here. I want to achiev this: Sum C5:C7 from all lists that contain word Teletnik and in the first list Formular you ...
2
votes
1answer
81 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
69 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
271 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
49 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
40 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
167 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
67 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
45 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
201 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
106 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
38 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
103 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
330 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
163 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
77 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
170 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
103 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
340 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
119 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
127 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
243 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
350 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
93 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
306 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
134 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
248 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
282 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 ...