| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Criteria range in a Dcount formula
Any help would be greatly appreciated.
I am getting an "invalid" response in the function wizard with the following criteria input. =dcount(datarange, 3, =("crit"&a100&c100)) where a100 is text and c100 is text. The desired outcome of the criteria is a range name for example: critav60fy08q1 or critav60fy08q2. The help screen mentions using 2 = signs i.e. ="=input" which I have tried with no luck. Thx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple criteria in dcount | Excel Discussion (Misc queries) | |||
| Using Dynamic Criteria with DCOUNT/DSUM | Excel Worksheet Functions | |||
| Excel Dcount multiple criteria | Excel Discussion (Misc queries) | |||
| Dcount with Multiple Criteria | Excel Worksheet Functions | |||
| Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
Linear Mode
