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.

Sorry, meant to write >U10000 in first column of criteria and <U100000 in
second column. Works fine if I use <U95000 in the second column.

Sorry for any confusion.

"JT Spitz" wrote:

> 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.