dsum returns 0 if criteria range too large
 

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.

dsum returns 0 if criteria range too large
 

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.