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
--
HTH

Bob Phillips

"Jennifer" wrote in message
...
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
--
Though daily learning, I LOVE EXCEL!
Jennifer