Thanks you , Not quite what I was looking for, but Ron got it for me.

In order for a record to be counted, Column C MUST be true AND either
Column A OR Column B (or both) must be true.


"Bernard Liengme" wrote in message
...
I had trouble with: "I want to be able to count a record if either column a
OR column B is true AND column C is true"

This counts one column =COUNTIF(A1:A7,TRUE)
This counts is BOTH A and B are TRUE
=SUMPRODUCT((A1:A7=TRUE)*(B1:B7=TRUE))
This counts is EITHER A or B is TRUE
=SUMPRODUCT(--(((A1:A7=TRUE)+(B1:B7=TRUE))0))
This counts if any 2 of three is TRUE
=SUMPRODUCT(--(((A1:A7=TRUE)+(B1:B7=TRUE)+(C1:C7=TRUE))1))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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