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

It sounds like that the cells being retrieved are really text.

I'd go back to the source (wch temp database!c4) and then reformat the cell as
general, then reenter the value (a two step process).

Then check the subtotal formula.

If that's corrected, it's time to fix all the values in those sending cells.



datakop wrote:

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

--

Dave Peterson