K klmcshane Nov 11, 2003 #1 How do I use a total from a function on a different worksheet within th same workbook