Solved: DCOUNT Excel Funtion

[Bruce T]

I am using DCOUNT function to extract information from a spreadsheet for subsequent use in a report. The information is counting set occurrences of a value of <10 and I have it working for >90 also. The problem is I need to report on >10 but <31, >30 but <61 and >60 but <91.

The problem is putting the criteria arguments in a cell. I just can't seem to find the correct syntax for it e.g. >10<31 doesn't work. If anybody could let me have the syntax I would appreciate it as I will probably need it in other excel funtions as well. Any help appreciated.

Bruce

[mikerickson]

If you want to find the records where 10 < Value < 31, you need a two column Criteria range (dots for spacing only)

Value....Value
>10......<31

[Bruce T]

Thank you I have got my spreadsheet working well now.

Bruce T