I see what you're saying but I wanted to do it all in one cell on the summary sheet for one reason. I receive the sheets to be summed from various sources and want to leave it as is. I basically pull those sheets into a master file where the summary sheet resides.