I have a worksheet that lists jobs with various identifying number ranges
differentiated by a preceding letter. E.G. C10000 through C90000 and U10000
through U90000. I am tyring to get subtotals on different fields for the
types of jobs we have in house. When I use a criteria range U10000 in one
column and U100000 in the next it returns "-" (result field is set up in the
accounting number format, else this would be zero)

If I use U95000 in the second column I get the correct and expected result.

Can anyone tell my why the higher limit is causing this problem. I have
also seen this in the C criteria.

Thanks.