When I tried to enter your code into a new spreadsheet file, I put the
data you said to into sheet1, as well as the line of code...

I renamed sheet2 "Income", and entered some data...

However, I get an "Invalid Cell Reference Error" on Sheet1 with your
forumula...


Any ideas?

I copied and pasted your line for Sheet1!C1 exactly.

Thanks!


--
Moomancow3k
------------------------------------------------------------------------
Moomancow3k's Profile: http://www.excelforum.com/member.php...o&userid=30339
View this thread: http://www.excelforum.com/showthread...hreadid=500025