Hi,

I am trying to sub total by Route, and get the break when the route number
changes, however the count is zero.

The cells I am trying to sub total are the result of an if statement, so
although I see the numbers, when I click on the cell, i see the formula. Is
there some way to have the sub total function just use the actual numbers?

I hope I have explained this properly. See below:


Route Number


=IF('WCHA Temp Database'!C4="","",'WCHA Temp Database'!C4)
105 This is cell C4
105
105
105
105
105
105
105
105
105
106
etc.

Thanks

Duncan