That works great thanks but I forgot to mention I only want the "-
symbol to appear if no data is enterd in the corresponding cells. Whe
I entyer data into the said cells the "-" stays in the sum cell. Don
suppose you know how to fix this aswell do you?

Thanks again

--
Message posted from http://www.ExcelForum.com