Countif?

[DES]

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

 

[Guest]

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

 

[Bernard Liengme]

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

 

[DES]

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

Obviously I am just a casual user.

 

[DES]

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.