One way:

=IF(SUM(B7:F7)=0,"",SUM(B7:F7))

In article <B5FAC831-EA6D-4F9A-8305-D1FF45AD39E7@microsoft.com>,
"billy_bags" <billybags@discussions.microsoft.com> wrote:

> in K7 I have the sum of b7:F7
> if sum b7:f7 = 0.00 then i want to leave k7 blank; but if there is data in
> b7:f7 I want the total
> my formula is
> =if(b7:f7=0,"",sum(b7:f7))
> With figures in this range the current response is #VALUE
>
> I know it must be simple and I thought I had followed the logical tests etc
> that appear to prompt you
> but.....
> appreciate your clarification
> Bill