# ROW formula generator

> Describe what you need and get a ROW formula for Excel and Google Sheets, run on real data before you copy it. Plus 8 tested ROW examples.

Source: https://spreadsheetpractice.com/tools/formula-generator/row · Updated October 29, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

ROW returns the row number of a cell: ROW(C7) is 7, and ROW() with nothing inside returns the row of the cell the formula sits in.

Describe the task at [ROW formula generator](https://spreadsheetpractice.com/tools/formula-generator/row) and get a ROW formula for Excel and Google Sheets, tested on real data.

## Tested ROW examples

### Return the row number of a matching value

`=MATCH(F1,A2:A9,0)+ROW(A2)-1`

Excel. Result on the sample sheet: 6. [See it and try it](https://spreadsheetpractice.com/formulas/row-number-of-matching-value)

### Create an ID with a prefix and leading zeros

`=$E$1&TEXT(A2,"00000")`

Excel. Result on the sample sheet: 5 rows (B2:B6). [See it and try it](https://spreadsheetpractice.com/formulas/create-id-with-prefix-and-leading-zeros)

### Sum every N rows in Excel (groups of rows)

`=SUMPRODUCT((INT((ROW($B$2:$B$16)-ROW($B$2))/$E$1)=D3-1)*$B$2:$B$16)`

Excel. Result on the sample sheet: 3 rows (E3:E5). [See it and try it](https://spreadsheetpractice.com/formulas/sum-every-n-rows)

### Find the last row with data in a column

`=XLOOKUP(TRUE,A2:A15<>"",ROW(A2:A15),,0,-1)`

Excel. Result on the sample sheet: 11. [See it and try it](https://spreadsheetpractice.com/formulas/last-row-with-data)

### Calculate a running total with ARRAYFORMULA

`=ARRAYFORMULA(IF(B2:B12="","",SUMIF(ROW(B2:B12),"<="&ROW(B2:B12),B2:B12)))`

Google Sheets. Result on the sample sheet: 11 rows (C2:C12). [See it and try it](https://spreadsheetpractice.com/formulas/running-total-with-arrayformula)

### Number each occurrence of a value

`=ARRAYFORMULA(IF(A2:A11="","",COUNTIFS(A2:A11,A2:A11,ROW(A2:A11),"<="&ROW(A2:A11))))`

Google Sheets. Result on the sample sheet: 10 rows (C2:C11). [See it and try it](https://spreadsheetpractice.com/formulas/number-each-occurrence-of-a-value)

### Get the last 3 entries for a customer

`=TAKE(FILTER(A2:C12,B2:B12=F1),-3)`

Excel. Result on the sample sheet: 3 rows (E3:G5). [See it and try it](https://spreadsheetpractice.com/formulas/last-3-entries-for-a-customer)

### Sum every nth row

`=SUMPRODUCT((MOD(ROW(B2:B11)-ROW(B2)+1,E1)=0)*B2:B11)`

Excel. Result on the sample sheet: $62,150. [See it and try it](https://spreadsheetpractice.com/formulas/sum-every-nth-row)

## Questions

### What does the ROW formula generator do?

You describe the task in plain English, and it writes the formula, using ROW where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.

### What does ROW do?

ROW returns the row number of a cell: ROW(C7) is 7, and ROW() with nothing inside returns the row of the cell the formula sits in.

### Can I learn to write ROW formulas myself?

Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the ROW function page has a practice exercise.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
