dsum returns 0 if criteria range too large

J

JT Spitz

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

JT Spitz

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