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