LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countifs in 2003 = _xlfn. ?? Steve Excel Worksheet Functions 12 December 29th 09 04:47 PM
Countifs equiv in 2003 Dan Excel Discussion (Misc queries) 6 August 26th 09 08:30 AM
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve Excel Worksheet Functions 2 January 4th 09 05:36 PM
COUNTIFS for 2003 Tromba Excel Worksheet Functions 4 April 13th 08 08:24 PM
excel's new countifs...on 2003? AndyBrown Excel Discussion (Misc queries) 1 July 20th 06 04:20 PM


All times are GMT +1. The time now is 12:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"