View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raymond W.[_2_] Raymond W.[_2_] is offline
external usenet poster
 
Posts: 16
Default 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