Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
First off, here is a sample set...
-------------------------- Database: MyCode Score Rating 9 641 22 G 649 23 9 675 23 J 649 23 M 999 95 B 529 21 -------------------------- and my Criteria: Rating MyCode 22 a 23 b c -------------------------- I can get a DCOUNT as long as I use a letter for the criteria under MyCode. What I need to do is get a DCOUNT of everything except the 9's (<9) in the criteria. BUT, everytime i put the <9 in, I get bad results. How do I count all the non numeric entries?!?! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Getting data from another workbook based on variable | Excel Discussion (Misc queries) | |||
Copying conditional formatting...HELP PLEASE!!!! | Excel Worksheet Functions | |||
SORT MIXED DATA | Excel Worksheet Functions | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
Adding more source data to existing scatter plot | Charts and Charting in Excel |