In article ,
j2thea wrote:

The formula doesnt work when I use Sheet2 references. I've tried usi ng it
on a different sheet, and the same sheet, but it doesnt compute correct
values.

Can you post the exact formula you're using?