0
votes
2answers
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 ...
0
votes
1answer
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| ...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
0
votes
1answer
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 ...
0
votes
0answers
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 ...
0
votes
1answer
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 | ...
2
votes
1answer
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 = # ...