# Questions tagged [iwork-numbers]

Numbers is a spreadsheet software included in the iWork productivity suite by Apple.

**1**

vote

**0**answers

22 views

### In Numbers/Excel how can I do a SUMPRODUCT only on rows matching a specific criteria

Let me explain my spreadsheet a little bit. Here is a good screenshot of it:
I have created this spreadsheet essentially because I have gotten tired of the usability issues of just about every ...

**0**

votes

**1**answer

22 views

### Formula in Excel or Numbers to generate a series of numbers

In my spreadsheet I have two numbers, start_number and nr_iterations. I'm looking for an formula that returns a series of numbers starting with start_number - 1 and nr_iterations long (each following ...

**0**

votes

**1**answer

8 views

### How does one add hours to a datetime in Apple Numbers?

I have one column that has a start date, and another column that has a duration field in hours. I cannot figure out how to add the hours to the datetime field.

**0**

votes

**0**answers

82 views

### Formula across sheets dependent on value on each sheet to include or not in Apple iWork Numbers

I am tracking my options trading, and as each position can span multiple transactions over time, including across year boundaries, I track each position from start to close on its own Sheet. I name ...

**0**

votes

**0**answers

13 views

### Imported CSV file into Numbers but cannot convert the numerals from TEXT to a usable currency format in order to calculate sums

Imported CSV file into Numbers but cannot convert the numerals from TEXT to a usable currency format in order to calculate sums.
How do I manage to format the columns the way I want? Numbers does not ...

**0**

votes

**1**answer

53 views

### Apple Numbers - Conditional formatting with equation

I want to color a cell green if it’s ≤ A1 × 2.
I can do this with a conditional formatting rule in Google Sheets, but conditional formatting in Numbers seems not to support equations, only ...

**0**

votes

**0**answers

48 views

### OSX Numbers, extending a chart data series

This link shows how to add a cell to a data series on a chart. However, my chart was imported from Excel and is several years old with over 150 columns and about 50 rows. I want to chart several of ...

**0**

votes

**1**answer

137 views

### Pasted tab separated plaintext doesn't end up in multiple cells

A recent update to Apple's Numbers seems to have removed or broken the ability to paste into multiple cells. Previously, if I copied the string A\tB\tC (where \t represents a tab character), I could ...

**0**

votes

**1**answer

64 views

### Spreadsheet: find a cell keyed by date

This is a question about Apple Numbers spreadsheet program.
Suppose I have two sheets: Benchmark and Training. In the Benchmark sheet, I track a benchmark value over time:
| Date | Benchmark |...

**0**

votes

**1**answer

106 views

### Convert Numbers file to Excel file

I have a spreadsheet created on a Mac using the software "Numbers".
In which way can I convert it into an Excel file to modify it on a Windows pc?

**1**

vote

**1**answer

117 views

### Sum specific cells if other cells match source cell in Numbers on Mac

So, I'm making a personal budget table that is similar to YNAB in functionality. I want to use Numbers but I can easily switch to Excel if this can't be achieved.
I have two sheets; Budget and ...

**0**

votes

**1**answer

78 views

### Remove non-duplicate rows from Numbers

I have Numbers file in Mac OS with 3 columns
GEO_ID GEO_ID2 FIPS
05000US01001 1001 12121
05000US01003 1003 28061
05000US01005 1005 21095
05000US01007 1007 28023
...

**5**

votes

**2**answers

147 views

### Determine United Airlines status level using worksheet functions

United Airlines MileagePlus Premier status levels are determined by a combination of criteria:
Silver: (PQM>=25000 OR PQS>=30) AND PQD>=3000
Gold: (PQM>=50000 OR PQS>=60) AND PQD>=...

**0**

votes

**0**answers

31 views

### Data Entry Beginner Asks: How do I 'section' out rows of a spreadsheet to belong to a product/item/object?

I am a complete beginner to data entry and wanted to know how to accomplish the following with the sample dataset provided below.
Search through quantity column for "equal to or greater than value of ...

**0**

votes

**2**answers

546 views

### How to add a row without changing formula in Numbers app on Mac

I have rows of data sorted by date (descending). Therefore it is important that a new row can be added above all other rows but before the "header" row.
However, when I select "Add row above" the ...

**2**

votes

**0**answers

439 views

### Apple numbers: How can I create a filtered column (B) with only unique values from column (A)?

I'm using Apple Numbers.
I have a table with data like:
A | B
---------+---------
Spain |
U.K |
Spain |
Germany |
U.K |
Italy |
And I would like to set table B to include ...

**0**

votes

**3**answers

81 views

### How can I count the number of cells that match a given month in Numbers

I'm using Apple numbers to run some calculations on CSV export data from Mailchimp.
The data is (loosely) like:
ID Email, SignupAt
01 me@example.com 2015-09-04
02 you@example.com ...

**5**

votes

**1**answer

7k views

### Apply formula to entire column using numbers app in osx

I use osx numbers app. I have a large CSV file. And I want to apply a formula for an entire column. Adding formula to a cell and then dragging is not practical. Isn't there any other way?

**0**

votes

**1**answer

51 views

### Extended Subtraction Between Columns on same row in area

I want to calculate the transaction value so by that i mean i've got different accounts in column "A" and for each transaction i got a column like "B".
The transactions show the new value, after the ...

**1**

vote

**0**answers

50 views

### Performing calculations on durations in iWork Numbers

I have a time sheet that I use to bill clients, with the following columns:
A: start time;
B: end time;
C: calculation of B - A, resulting in the duration of time worked;
D: Project name
On another ...

**1**

vote

**1**answer

892 views

### iwork numbers and apple Swift language relation

Is there any way to write Microsoft office Excel macros like scripts for iWork numbers code using apple's Swift programming language?

**1**

vote

**1**answer

35 views

### Full grid canvas in Apple Number

Apple Number have a default blank canvas shaped as a sheet with margins.
Is it possible to change the default blank canvas to an endless grid like Microsoft Excel?

**0**

votes

**2**answers

692 views

### Find the number of cells to sum to reach a certain amount

I have a column of values (they are ordered if that matters): A:A. I have two values: a starting value B1 which is also present somewhere in A:A, and a goal value C1.
Let's say the we can find the ...

**0**

votes

**1**answer

25 views

### Numbering lists in Apple's Numbers

This should be so simple.
I am attempting to use "Numbers" Mac's spreadsheet program. All I want to do is make a list of people and number them. I want the gridlines - and I want the list of ...

**0**

votes

**0**answers

36 views

### Numbers or Excel, Sum data in a column depending on date

I hope to Sum Column Y based on data in column A. That is, If A is in (contains) "July", then sum Y. i.e. "What are the totals for July?

**4**

votes

**2**answers

2k views

### In Excel (or Numbers) what formula can calculate the amount of days in a certain month across 2 dates

If a guest arrived on 24th of August and left on 4th of September what is the formula(s) to calculate how many nights are spent in August, and how many nights are spent in September?

**1**

vote

**0**answers

354 views

### Go to specific row number in Numbers (OSX)

Is there a way in Numbers to go to a specific row number?
For example I need to find an alternate way to not have to scroll but rather can immediately go to row # 3000.

**1**

vote

**1**answer

1k views

### Display Last Value from End of Row in iWork Numbers

In iWork Numbers (v3.5.2) I would like to display the last value (not int or bool) from a row. I have an image of what I'm looking to do below.
In row 1 I have the Current pulling the value from the ...

**0**

votes

**1**answer

5k views

### Spreadsheets Formula Check In/CheckOut Autopopulate Data

I am working on a spreadsheet (I am doing it in Numbers since it will easily let me work on the file on my mac, iPhone, iPad and online at icloud.com)... but this is essentially also an excel question ...

**0**

votes

**1**answer

24 views

### Val2 function in iWork Numbers?

Is there equivalent Excel Val2() function in Numbers? I want to get value of a cell, which contains formula. What I need to get the result text from the cell.
The following is example data:
A B ...

**1**

vote

**0**answers

395 views

### Pull multiple rows of data from one place in spreadsheet to another based on a condion

I have an iWork Numbers (3.2 - 1861) sheet with a list of people with the following structure:
| Name | Age | Email | Condition |
| Bart | 12 | test@test.com | ...

**0**

votes

**0**answers

62 views

### Make a column be unaffected by any row in Excel?

Basically I want to keep a particular column unaffected by any row deletion (by unaffected, I mean no contents of that column are shifted). Is this even possible?

**3**

votes

**1**answer

1k views

### Categorizing data based on a column in Numbers 3.X

I have recently migrated to numbers 3.0.1 on my MAC. I am not seeing the option "Categorize by this column" anymore. Any idea how do we group the data in new numbers based on a column.

**0**

votes

**2**answers

422 views

### Define a range based on the result of the INDEX function

In Excel it is possible to write a function looking like that:
=SUM(A1:INDEX(...))
Where the end of the range of the data to sum is dynamically defined by the result of the INDEX function.
The same ...

**0**

votes

**1**answer

303 views

### How can I do this in spreadsheets?

Let's say you have a table like this:
| A | B | C |
-------------------------------------
1| sex | age | answer q1 |
-------------------------------------
2| ...

**-1**

votes

**1**answer

367 views

### Rearranging spreadsheet data

If I have the following data table:
Country 1990 2000 2010 LEB 1990 LEB 2000 LEB 2010
Afghanistan 15 17.72 18.24 48.60 54.86 59.61
...
How would I in an automated ...

**1**

vote

**1**answer

105 views

### How do I lookup using 2 values, Verticle and Horizonal? (Apple Numbers)

I have a sheet that has an individuals info, one table as their Age (TABLE 1). Another Table has a score in cell (TABLE 2). I want to lookup the VALUE that corresponds with their age and score in ...

**0**

votes

**1**answer

35 views

### In one end of table cell, concat all text from Cell A when Cell B is blank

I've got a spreadsheet of potential expenses in Numbers.app.
Text String | $Price
In some rows, the $Price cell is empty.
I'd like to iterate over all the rows, and when $Price is empty, CONCAT ...

**0**

votes

**1**answer

368 views

### Numbers/Excel Hour Counter within Specified Date Range

The data shown in the image is just sample information but...
I would like to use the "Period Beginning" and "Period End" to create a range to determine the total number of hours and earnings. I have ...

**0**

votes

**2**answers

253 views

### Excel/Spreadsheet - formula for last value in a row?

I'm trying to forecast increasing vendor costs in a spreadsheet.
My sheet looks something like this
col | A | B | C | D | E | F
vendor | 2013-09 | ...

**0**

votes

**1**answer

393 views

### Aligning split columns in a spreadsheet

I'm using Numbers, but I think excel users would also know the answer here.
All I want to know is, how can align the 'amount' column with the columns below it, and the 'total' column with the columns ...

**6**

votes

**1**answer

7k views

**0**

votes

**1**answer

38 views

### How does one add all values that occur before a specific date?

I know I need the SUMIF function, but I can't figure out the condition for the life of me. Given the following table, how would I get $150?
Value | Date
------+---------
$100 | 1/1/2013
$50 | 1/...

**3**

votes

**1**answer

3k views

### Numbers conditional formatting based on a different cell in the same row

I have a Numbers spreadsheet, with "quantity required" and "quantity in stock" columns, then each part is on a row. I'm trying to use conditional formatting to turn a cell yellow when # required = # ...

**3**

votes

**1**answer

2k views

### Sum the first N elements in a spreadsheet column

I'm trying to sum the first N elements in a column, where N is a value in another cell.
I've come up with this:
=sum(B1:indirect(concatenate("B", A10)))
Where A10 contains N. But I don't want to ...

**0**

votes

**1**answer

369 views

### Numbers is no longer shipped with OSX from Mountain Lion?

I heave heard that Mac OSX Snow Leopard shipped with Numbers, an app used to manipulate spreadsheets. But I can't find it inside my default Mac OSX Mountain Lion installation. Checking with App Store, ...

**1**

vote

**1**answer

2k views

### Quickly increase/decrease cell value by 1 in Numbers

Is there a quick way to increase/decrease a cell value by 1 in Apple iWork's Numbers?

**6**

votes

**6**answers

1k views

### Does any spreadsheet allow you to create your own functions?

I've always been frustrated when using spreadsheets by the inability to define my own functions when there is no existing function to (cleanly) do what I want. Does any spreadsheet offer this ability?...

**1**

vote

**2**answers

72k views

### Pull row of data from one place in spreadsheet to another

I have a list of names and their assorted properties.
I am trying to find a way to quickly move an entire row's worth of data into a different sheet so I can manipulate it.
Currently I can ...

**3**

votes

**0**answers

229 views

### In Numbers for Mac, possible to have custom formatting depending on value of other cell?

I have several columns of numbers, and I want to highlight one of those with a background color.
I have created a single cell at the top of these columns, that for each column contains either a 1 (...