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
52 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
458 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
99 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
379 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
39 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
148 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
278 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
365 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 ...
1
vote
1answer
194 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
49 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
240 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 ...
0
votes
1answer
141 views

Numbers: is it possible to add multiple select elements?

I'm working on template in Numbers. Some cell in template can have only specific values from code lists, so I decided to add pop-up format for them. But some cell can have multiple values from code ...
2
votes
2answers
5k views

How do I separate multiple comma separated values in Numbers

So, one of the CSV files I'm using has lumped the address into one single cell, separated by commas. For example: 12 Fairy Tale Lane, Wonderland, Oz, Neverland I need to separate these into Address ...
0
votes
1answer
148 views

How do you formulate Microsoft Excel “if” statement equivalent in Numbers?

The syntax of a simple Excel if statement is: =IF(a1="a",b2,"") This places the contents of cell b2 in the current cell if cell a1 contains the character "a". Otherwise the current cell is cleared. ...
0
votes
2answers
170 views

Apple Numbers program, weird thing with unix time code formula

Hi I have applied the unix time code formula =(((A1/60)/60)/24)+DATE(1970,1,1)+(-5/24) And it works! But the result I get on my column only shows the date and not the time. Does anyone know how to ...
2
votes
0answers
344 views

Do Pages, Numbers and Keynote for Mac/iOS offer real-time collaboration on shared documents like Pages, Numbers and Keynote for iCloud do?

In Pages and Numbers (I guess Keynote too) for iCloud if you share a document and then send the link to other people you get real-time collaboration between the contributors as they edit the document ...
1
vote
1answer
301 views

Get cell value by address string in Numbers

In Numbers 3.5.2 I manage to get a cell address sting (I compute it based on some data). Now when I have it, how can I get the value behind that address without copying the result of my function to ...
0
votes
0answers
103 views

When does Numbers sync spreadsheets?

In Numbers, connected to wifi (good bandwidth), after modifying a spreadsheet I go back to "Spreadsheets". Then I wait for the Arrow ↑ to appear, as it indicates that Numbers is syncing with iCloud. ...
1
vote
2answers
165 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 ...
2
votes
0answers
52 views

Looking for a grandma-safe way to create two-fold greeting cards

My Mom (+ 70) longs for the day when her Windows Paint Shop program would walk her through creating a 2-fold 8 1/2 x 11 card. She could assemble the card one page at a time and not think about what ...
0
votes
0answers
121 views

How to use Numbers to generate pdf on a web server and then email it out?

I have an issue. My client loved the report I generated using Numbers on Mavericks OS X. The bad news is that the data is being processed on a ubuntu machine running python and django. I want to ...
0
votes
1answer
172 views

Numbers - date cell set to last day of the month

I have a Numbers sheet that I use to forecast the monthly interest payments on my mortgage and it's working well. The only issue is that the date cells auto-sets to the first day of the month. Is ...
0
votes
2answers
369 views

Numbers: VALUE function does not recognize empty string

I am using Apple Numbers and find it frustrating that cell arguments containing empty text (and sometimes contain numbers from other sheets) are not converted to a number of value 0, when referenced ...
0
votes
1answer
207 views

How to convert to millions in Mac:Numbers?

I understand in Microsoft Excel you would use the format string $#.##,," M" so that 12,271,359 would appear as 12.27M I am alittle confused with the Numbers app on Mac (the excel equivalent) and I ...
0
votes
1answer
2k views

Creating an adding and subtracting formula in Numbers

I'm creating a financial spreadsheet and need to ask the spreadsheet to calculate the new balance after subtracting and adding sums. For example, I want to calculate the running total in E column. I ...
2
votes
1answer
2k views

Greyed out Hide Column command

In iWork Numbers, why is the command Hide Column greyed out? What format do I have set up that does not allow me to hide that specific column? I have un-merged all the cells.
1
vote
1answer
29 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 ...
2
votes
0answers
555 views

batch convert iWork 08 files to new version on Yosemite

TL;DR Short version: I have a bunch of files that were created with iWork 08. Is there a way, maybe using AppleScript or Automator, to convert them to the new format (Pages 5.5, Numbers 3.5) without ...
2
votes
1answer
108 views

Why does CMD+1 work if using my top row numkeys, but not my right-side NumPad? Mac

I use a lot of keyboard shortcuts, like CMDkey + 1. However, that 1 has to be from my top row numeric keys. If I try using CMDkey plus a number from the NumPad on the right side of my keyboard - this ...
1
vote
2answers
1k views

How do I insert a row into numbers, in just one column

How do I insert a row in one column only. By moving the current data down and inserting a row above it. I don't want to insert a row across the entire spreadsheet - just that column.
0
votes
0answers
293 views

Template for solving systems of equations in Numbers?

Can anyone direct me to a template, method, or example for solving systems of equations with Numbers? Excel supports this with its SOLVE facility, but I see nothing obviously like that in Numbers. ...
0
votes
1answer
477 views

Cannot update Numbers document on iPad

I have a Mac, running OS X 10.10.2 and an iPad Mini running iOS 8.1 Both have the latest version of Numbers. I have a spreadsheet, which I update roughly monthly on the Mac. I have transferred this ...
1
vote
2answers
3k views

Linking between tables in Numbers

I have a table in numbers, and I want a cell to equal the value of a cell in a different table. Following the advice of this Apple discussion, I tried =Units Sold::B2 , with Units Sold being the ...
1
vote
1answer
43 views

Increase precision in numbers

In Numbers, when I enter 0.981, it gets automatically formatted as 1. How can I increase the precision? When I double click on the cell I can see 0.981 but as soon as I deselect it, it goes back to 1....
0
votes
1answer
1k 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 ...
0
votes
1answer
421 views

How do I do a COUNTIF on another table column in Numbers?

I am on 2014 Macbook Pro running Mavericks. I have two tables. In table 1, I have a cell that should store the number of cells in column A of table 2. In the same table 1, I have a different cell ...
2
votes
1answer
782 views

Open new Numbers document in older Numbers

I have a Numbers (v3.5) file from a Yosemite install. I have since abandoned Yosemite (here is why WindowServer high CPU on Yosemite). Now I cannot open this file in Mavericks' Numbers (v2.3) app. I ...
1
vote
3answers
3k views

How do I delete one of my custom templates in Numbers - OS 10.10.1

I would like to delete one of my custom templates I made in Numbers - in previous OS versions you went to Library>iWork>Numbers>Templates and just trash it - but, since I updated to Yosemite - I only ...
0
votes
2answers
270 views

Numbers V3: If cell contains a value, convert cell value to X

I have a spreadsheet which contains a mixture of text strings and empty cells. I'm looking for a formula to replace the value of all non-empty cells with a single character 'x', while leaving empty ...
0
votes
1answer
805 views

Applescript read specific data out of iWork Numbers

I am trying to get data out of a table in Numbers. I have an index number, I need to get the name associated with it in applescript. (Eventually I need to set names of files with one of columns of ...
2
votes
4answers
719 views

How to open numbers spreadsheet in 2 separate windows

I often find it useful to have two tabs of one spreadsheet open in separate windows. In Excel this is easy (Windows/New Window). Is there any way to achieve this in Numbers (as of Version 3.5)? For ...
1
vote
1answer
1k views

How to visualize calendar dates (in Keynote? Or Numbers?)

I am having trouble visualizing dates in a presentation. This image is a good example of what I'm hoping to have, but I would like a way to make the slide from a table of dates (rather than making ...
3
votes
0answers
414 views

Changing the open with settings in 10.10.1

I am looking for a way to edit the open with settings in 10.10.1, i have looked through older questions and have attempted to rename the launch services plist and have gotten no where. I have looked ...
1
vote
0answers
437 views

How can I link data from Numbers to a Pages document? [duplicate]

I'd like to have all my client invoices in a Numbers document, including invoice number, service period, daily rates,... and generate a invoice from that with a template I have created in Pages. How ...
3
votes
3answers
5k views

Auto-Populate A Pop-Up Menu in Numbers 3.5

I'm trying to steer clear of Excel, despite my sister's nagging, and I've done pretty well to create a Quote and Invoice workbook in Numbers. The problem I am having is working out how to ...
0
votes
2answers
2k views

Set Print Range in Numbers.app

Is there any way to set a print range in Apple Numbers.app spreadsheets, to print just a subset of cells rather than entire document?
0
votes
1answer
145 views

Apple Numbers '08: extending a formula

How can I get a formula to apply to every cell in a column? (i.e., I want to subtract a number I just entered in one cell from a total I have in a previous cell and I want to do it each subsequent ...
0
votes
1answer
921 views

How to hide columns

The old version of numbers had a "hide column or row" feature. I could right click a column and the "hide" option appeared on the same window as "add/delete" and "merge." However with the 3.2 update I ...