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

learn more… | top users | synonyms

3
votes
2answers
686 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?
0
votes
1answer
4k views

Select each nth row in Numbers

I have an iWork Numbers spreadsheet with thousands of rows. How can I select every 5th row from that spreadsheet? See also: Select each nth row in Excel
3
votes
1answer
1k 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 ...
1
vote
1answer
1k views

Spreadsheet formula to count consecutive values in a column

I have a column with "Y" and "N" values, and need a formula to count the last consecutive occurrences of "Y". So if I the column looks like this: Y Y Y N Y N Y Y the desired result would be 2 Y Y ...