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
10 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
2answers
314 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.
0
votes
0answers
9 views

In Numbers, how can I show a formula instead of the result?

I want selected cells to show the formula instead of the result of the formula, for example cells C4 and D4 here. If the cell is formatted as text before I enter the formula, then the formula ...
0
votes
0answers
8 views

OSC Yosemite Numbers: conditional sum based on text of cell [duplicate]

I saw this answered for iWork a good few years ago but the work round doesn't now. I used this a lot in Excel and need it in Numbers. Help much appreciated. My query is exactly as the first time it ...
0
votes
0answers
9 views

Numbers: How to merge multiple sheets of products into one sheet, automatically update on change of data

What i'm trying to achieve is a database for food products split into three categories:- Frozen, Ambient and Chilled. Each category is on a separate sheet which is the data and in each category it ...
3
votes
2answers
41 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
votes
0answers
21 views

Consolidating multiple sheets into one Numbers 3.6.1 OS X

I'm looking for a solution to automatically merge/consolidate the data from multiple sheets into one. I would like to stack the sheets on top of each other in it's own sheet. I would like to be able ...
1
vote
2answers
29 views

Conditional highlighting of booleans in Apple Numbers

Is it possible to do conditional highlighting of booleans in Apple Numbers? I want to highlight TRUE values one way, and FALSE values another, but booleans don't seem to be supported - only numbers, ...
1
vote
1answer
12 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 ...
0
votes
0answers
19 views

Exporting from Numbers to CSV file

I am trying to export a spreadsheet out of Numbers into a CSV file. I know where and how to do this, however the file that is created is still generating a formatted table rather than having the ...
0
votes
1answer
33 views

Is there a formula or function for Numbers that returns the number of days or weeks for a given year

I have a budget table with cost per week, fortnight, month, quarter and year. Some expenses are charged quarterly and others monthly or weekly, but I want to know what the value of a cell is for the ...
0
votes
0answers
21 views

How to copy one cell's value to other cells of the same date in Numbers?

Given one spreadsheet in Numbers as the following. Column A is datetime, and column B is the value. For each date (ex, 2015-12-01), there is just one cell with non-empty value on 05AM. Ex, there are ...
0
votes
1answer
16 views

How do you remove a hyperlink from a cell in Numbers '08 version 1.0.3?

I have an address in a cell which is hyperlinked. I've also searched other posts on the topic and the selecting text and "right-clicking" does not bring up a menu with how to remove the link. I'd ...
-1
votes
1answer
72 views

How do I start rows with 0 (not 1) or not count header rows in Numbers?

I'm using the Numbers app to make a database or catalogue of stuff. For example, a list of all wines I'll try this year. And for each column, I'll have the name of the wine, a rating, the kind of ...
0
votes
1answer
54 views

Number 3.6.1: Cell value needs to be invisible, if the adjacent checkbox is checked

I'm not sure if this is the right forum, but here goes: I would like to keep the cell value (E8), if the adjacent cell (D8) is false (checkbox is not checked), else insert zero or null. I just keep ...
4
votes
2answers
88 views

How to get the month name in English using Numbers?

I'm using Apple Numbers v 3.6.1 on OS X 10.11 to automatically fill all the info I need to generate a receipt each month. "... " & MONTHNAME(MONTH(TODAY())) & " 1 − " & ...
0
votes
1answer
29 views

Repeating a formula for every row in Pages

I'm working on a simple formula in Pages where I have a table with 4 cells per row. Product Name, Purchase Price, Quantity and Total. I've created a simple formula that multiples Purchase Price ...
1
vote
1answer
20 views

Display point values on numbers graph

On an Excel graph, if I mouse-over a data point on the graph, the application shows me in a small pop-up window the exact X and Y data values of the point that I am mousing-over. Is there a way to do ...
0
votes
0answers
53 views

“Database” report writer for Numbers?

I serve on the Board of a Baroque Orchestra and have begun helping them get organized. The management of the orchestra does not have extensive technical skills so I've endeavored to help provide them ...
1
vote
2answers
43 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
15 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
18 views

Numbers Between Formula

IF(AND(B13≤74,B13≥75,B13>90),"0","3, 5") Hey guys im basically trying to generate a if statement that outputs either 0 if under 74 or under 3 between 75 - 89 and 5 for over 90. I have been trying ...
0
votes
1answer
50 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
42 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
33 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
43 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
20 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
112 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
27 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
32 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
47 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
12 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
33 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
19 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
36 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
20 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
30 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
22 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
18 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
99 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
29 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
96 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
29 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
57 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
45 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
147 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
42 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
8 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
22 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 ...