Sandy Mann wrote:
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.


cheers for that, but no, zero would never be a possible answer, so first
is great

thanks again :)