# dynamic range

#### mcarter973

##### Board Regular
i have the following formula in each tab of a worksheet (where each tab is a month of the year):
sumif(A20:A1000,A1,B20:B1000)
sumif(A20:A1000,A2,B20:B1000)
sumif(A20:A1000,A3,B20:B1000)

currently, the last nonblank cell is in row 609. how can i reference row 609 in my formula (the last nonblank cell changes in each tab).

Thanks.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
On 2002-10-01 11:52, mcarter973 wrote:
i have the following formula in each tab of a worksheet (where each tab is a month of the year):
sumif(A20:A1000,A1,B20:B1000)
sumif(A20:A1000,A2,B20:B1000)
sumif(A20:A1000,A3,B20:B1000)

currently, the last nonblank cell is in row 609. how can i reference row 609 in my formula (the last nonblank cell changes in each tab).

Thanks.

I posted many times on how to create dynamic ranges... See, for example,

http://www.mrexcel.com/board/viewtopic.php?topic=16207&forum=2&7

You need to apply the method per worksheet.

Replies
1
Views
453
Replies
0
Views
672
Replies
3
Views
237
Replies
3
Views
269
Replies
4
Views
329

1,221,493
Messages
6,160,139
Members
451,624
Latest member
TheWes

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back