I would make a "Helper" column and then just count the "true" values:
Example:
Cell A1=no
Cell B1=yes
In cell C1 - enter the following formula =AND(A1="no",B1="yes") - then
copy down as far as you need.
This should equate to "TRUE" in C1 - Then you just use a formula to
count the number of TRUE's in Column C - using the COUNTIF function.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=534737