Another "If" Question. (I'm learning)

[Athalon]

Okay- Two Rows. Each cell contains either a "True" or a "False". If two cells next to each other both have trues, I want it counted. =COUNTIF(M5:M782;"TRUE");(N5:N782,"TRUE"). This formula does not work. Please "Stear me straight". thanks.

[David]

[RickRandom]

The 2 step answer could be, with your rows of TRUE and FALSE in A1 to D4:

1. In A3, put:

=AND(A1;A2)

and fill across into B3, etc.

[You could just use =A1*A2 because Calc treats TRUE as 1, FALSE as 0.

2. Put in A4:

=COUNTIF(A3:D3;1)

[You can put TRUE instead of 1, but it changes to 1.]

I expect there are better ways, perhaps using SUMPRODUCT( ) if your TRUEs and FALSEs are in arrays, but I don't use arrays, so don't know the details.

Let us know your success or failure, in the latter case someone will try again.

Well I looked at SUMPRODUCT( ) and it worked! Use:

=SUMPRODUCT(A1:D1;A2:D2)

I get an answer of 2, as I've got TRUEs in C1, C2, D1, D2.

So at least I've learnt something.

[Athalon]

It Worked David. The idea is to get a whole row of 1 or 0 and then do a countif at the bottom. I was not thinking this way but it worked. Thanks a bunch. Until next time. Matt