I would like a cell (total) to sum 6 other cells only if one of those 6 cells have a value. If none of the six have a value i do not want anything to appear.

Blank if no cells contain data (i.e. all completely empty):
Blank if no cells contain numbers (will also blank if they contain nonnumerical data):
The difference is There's also a 


I am assuming that you may even have negative numbers at times, and this will not work if the inputs are not numbers. Also am assuming you meant, you would like a total if there is a number in ANY of the 6 cells.
or since positive and negatives would be entries but total zero perhaps
even a textual entry would be noticed but not add to a total. Not sure if that is acceptable either 


I tried this on open office. May work. 

