Actually I just had a thought, if it is possible that zero could be a
legitimate answer, (ie positive & negative values in the range), then

=IF(COUNT(your range)=0,"",Sum(your range))

Would be a better option.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Remo Shiva" wrote in message
. uk...
Sandy Mann wrote:
I assume that your cells are formatted as Accounting and the dashes
indicate a zero. If so try:

=IF(SUM(your range)=0,"",Sum(your range))



thanks so much, works perfectly