This worked on Sheet1 when List1 was on Sheet2

=SUM(Book2!List1)


You can also look at hiding columns and/or rows.

Another is to Custom Format the number of list cells with ;;;
Uncheck the protection for all other cells, and protect the worksheet.
(just be aware that protecting a worksheet with or without a password won't
keep everyone out.
--
steveB

Remove "AYN" from email to respond
"Man Utd" wrote in message
...
Can I hide the data in a cell range ?
I have some data in a cell range for lookup, say, K10:N30 as MyDataList, I
don't want to show to a user, can I hide these data ?
I think I can put these data on another worksheet and hide that worksheet,
but I don't know how to reference this lookup table in the formnula.