You could sub-total on each worksheet - this would tidy-up your final
formula - but the bottom line is you can't add up a number of cells
unless you identify them!

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=504328