Thanks, works perfectly. I forgot that true=1 and false = 0

Obviously I am just a casual user.


"Ron Coderre" wrote in message
...
With
A2:C500 containing True/False values

This formula returns the count of rows where
either Col_A or Col_B is TRUE
AND where Col_C is TRUE

=SUMPRODUCT(((A2:A500+B2:B500)0)*C2:C500)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"DES" wrote:

Ok this should be trivial to do, but I am going blank today.

We got 425 questionnaires back from a survey we sent out.
I have 3 columns of True or false.

I want to be able to count a record if either column a OR column B is
true
AND column C is true

I know this should be easy but just cannot get it to work.


TIA
--
Darrell
Play every game as if it were your last....
Someday you will be right.