Boolean AND results of an array

[bebiba]

I need to determine the boolean AND result of a row from the rows that have a match in one of the cells

In my example, I have 6 rows. Column A is the value that I am matching. Column B is the result of another formula which results in a true/false
I want to find all rows that have the value in column A.
For example, for row 2, I want the result of an AND of all rows that have "A" so rows 2 and 3 which would AND a TRUE and TRUE resulting in a TRUE
For row 6, I want all the results of column B who have a match of "C", so rows 6 and 7 which would AND a true and false resulting in a false

I think it's because I am not actually ANDing them together, but any attempt to include AND in the formula in column C resulted in an error

Please ignore the fact that I am matching multiple values together. Right now, they are all doing the same match, but eventually I will add in multiple criteria for the match

Any help would be greatly appreciated!

[AliGW]

Please explain the logic of your expected results. What exactly are you trying to calculate?

[Bosco]

Maybe,

In E2, copied down :

=COUNTIFS($A$2:$A$7,A2,$B$2:$B$7,TRUE)=COUNTIF($A$2:$A$7,A2)

Regards

[bebiba]

Thank you Bosco.. .Seems to work.. I have marked it as solved, but I am not sure I understand the logic behind the solution.