Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use DCount to exclude data?
I am trying to exclude price ranges from <100,000 to 150,000 from my
database, my criteria range is B9:C10. Price <100000 Price 150000 These are on 2 separate lines. I have my database entered and "price" as my field range, but my criteria range is wrong. I am using Office XP. How do I set this up? T Lodge |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude data from summary totals when hidden | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
exclude data already imported in excel | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel |