software

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 quot;-quot; (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 gt;U10000 in first column of criteria and lt;U100000 in
second column. Works fine if I use lt;U95000 in the second column.

Sorry for any confusion.

quot;JT Spitzquot; wrote:

gt; I have a worksheet that lists jobs with various identifying number ranges
gt; differentiated by a preceding letter. E.G. C10000 through C90000 and U10000
gt; through U90000. I am tyring to get subtotals on different fields for the
gt; types of jobs we have in house. When I use a criteria range U10000 in one
gt; column and U100000 in the next it returns quot;-quot; (result field is set up in the
gt; accounting number format, else this would be zero)
gt;
gt; If I use U95000 in the second column I get the correct and expected result.
gt;
gt; Can anyone tell my why the higher limit is causing this problem. I have
gt; also seen this in the C criteria.
gt;
gt; Thanks.