Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not understanding COUNTIFS workaround in 2003
I have been reading up on how to work around the lack of a COUNTIFS function
in 2003, but am apparently not doing something correctly. I have a column with three possible answers (high, low, moderate) and a column with two (True, False). I am wanting a total count of all rows that contain both "High" and "False". I either get #VALUE! errors, or counts of 0 regardless of the data entered. I am testing the code on '07, but will be running the sheet on '03. If VBA is the only way to accomplish this, I am fine using that, just need some pointers in the right direction. Oddly enough it seems to work if I use something other than true or false, but that is the wording at my disposal...I feel as if I am beating my head against an invisible wall. If I cannot make it see TRUE or FALSE I suppose I can use an IF statement elsewhere to change it to a 1 or 0 and use that column instead... but that just seems like extra bloat. Thanks in advance for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countifs in 2003 = _xlfn. ?? | Excel Worksheet Functions | |||
Countifs equiv in 2003 | Excel Discussion (Misc queries) | |||
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr | Excel Worksheet Functions | |||
COUNTIFS for 2003 | Excel Worksheet Functions | |||
excel's new countifs...on 2003? | Excel Discussion (Misc queries) |