dynamic range

[mcarter973]

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.

 

[Aladin Akyurek]

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.