# Tagged Questions

37 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 ...
64 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| ...
28 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 ...
21 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 ...
113 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 ...
124 views

### iWorks Numbers: Copy a range of data from one sheet to another using IF statements?

Please help....I am using an Apple (iWork's) Numbers spreadsheet with 2 sheets. I would like to copy a range of data from one sheet to the other, I thought the best way would be using "IF" statements ...
24 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 | ...
493 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 = # ...