3 comments:
You don't need UPPER, as the comparison is not case sensitive.
You don't need the double unary minus if you are using the * operator to
multiply.
As others have suggested, in your formula you need to be careful to
distinguish between a text "TRUE" and a logical value TRUE. The quotes make
it text.
--
David Biddulph

"Gary Keramidas" <GKeramidasAtMSN.com wrote in message
...
this seemed to worked for me.

=SUMPRODUCT(--(UPPER(A1:A9)="HIGH")*(UPPER(B1:B9)="TRUE"))

--


Gary Keramidas
Excel 2003


"Raymond W." wrote in message
...
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