| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Dcount multiple criteria
I have these criteria(all need to be fulfilled):
Date Venue Ticketype Postcode However I want to be able to enter two venues sometimes, and only one other times. I use Dcount, however it does not work, if I have two criteria one beneath the other eg: Venue York Castle =DCOUNT(Data!A1:G200,,A10:F12) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dcount with Multiple Criteria | Excel Worksheet Functions | |||
| DCOUNT WITH MULTIPLE CRITERIAS | Excel Worksheet Functions | |||
| Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
| DCOUNT in Excel | Excel Worksheet Functions | |||
| DSUM and DCount when criteria values are similar | Excel Worksheet Functions | |||
Threaded Mode
