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

learn more… | top users | synonyms

1
vote
1answer
595 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 ...
0
votes
1answer
2k 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
616 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 ...