PDA

View Full Version : Solved: DCOUNT Excel Funtion



Bruce T
12-11-2008, 05:00 AM
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
12-11-2008, 06:53 AM
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
12-11-2008, 07:29 AM
Thank you I have got my spreadsheet working well now.

Bruce T