R
Raymond W.
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
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