jahoobob Wrote:
Try these formulae:
In H5 =IF(SUM(C5:F5),SUM(C5:F5)," ")
In I5 =IF(SUM(C5:F5),I4-G5+H5," ")

Thanks for your help, I wound up using:
In H5 =IF(SUM(C5:F5)=0,0,SUM(C5:F5))
In I5 =IF(SUM(G5:H5)=0,0,I4-G5+H5)

Then I used conditional formatting to hide the zeroes in the rows
without data.
Not perfect, but it's good enough for what I need. I can manually over
ride the few glitches I've come across.

Thanks again for your help.
Nepe


--
Nepe

=IF(SUM(C5:F5)=0,0,SUM(C5:F5))
could be replaced with just:
=SUM(C5:F5)

If it's 0, it'll show 0.

Nepe wrote:

jahoobob Wrote:
Try these formulae:
In H5 =IF(SUM(C5:F5),SUM(C5:F5)," ")
In I5 =IF(SUM(C5:F5),I4-G5+H5," ")

Thanks for your help, I wound up using:
In H5 =IF(SUM(C5:F5)=0,0,SUM(C5:F5))
In I5 =IF(SUM(G5:H5)=0,0,I4-G5+H5)

Then I used conditional formatting to hide the zeroes in the rows
without data.
Not perfect, but it's good enough for what I need. I can manually over
ride the few glitches I've come across.

Thanks again for your help.
Nepe

--
Nepe

--

Dave Peterson