Hi Jess

Just prefix the range with the sheet name and an exclamation mark e.g.

Sheet1!$A$1:$A$100
'My Data'!$A$1:$A$100

Note that if you have spaces in the sheet name, you must enclose the
name within single quotes.

--
Regards

Roger Govier


"Jess" wrote in message
...
Hi! I have a similar query, i know how to use the sumproduct function
in
rgard to my data, what i want to know is how to refer to column in
another
sheet.
Thanks