Using Offset to name a range

J

Jennifer

I have a worksheet that filters data to
b17 through k(row number will vary)
can someone tell me what is wrong with this function?
I admit i have a rough time with offset!
=OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B,1),COUNTA(GwrStmts.!$2:$2))

Thank you-Jennifer
 
A

arno

Hi Jennifer,
=OFFSET(GwrStmts.!$B$17,0,0,COUNTA(GwrStmts.!$B:$B,1),COUNTA(GwrStmts.!
$2:$2))

write the count-formlas in cells and check the result they give. are
they doing what you want?

arno
 
B

Bob Phillips

Jennifer,

This seems to work for me

=OFFSET('GwrStmts '!$B$17,0,0,COUNTA('GwrStmts '!$B:$B,1),COUNTA('GwrStmts
'!$2:$2))

If the sheet really does have a trailing space in the name, you need
apostrophes
 
Top