D
datakop
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
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