Formula to count how manytimes the word true happens in a row

[pagsju]

Hello!

I've been trying to create a formula that counts when the word "True" happens more then once in a row. But no success.

example:
False
True
True
False
True
False


So in the example it would be 1 as a result.
I can't figureout how to do it.

Any ideas?

[FDibbins]

Hi, welcome to the forum

(I think you mean column?)

=COUNTIF(H:H,TRUE)

Adjust the H:H as needed

[pagsju]

Thank you

the =COUNTIF(H:H,TRUE) counts everything that is true?
I need it to count only if it's true more then once.

I appriciate the fast answer though!

[bebo021999]

Try this array formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[pagsju]

Thank you very much bebo021999
I will try this when i get home.

[pagsju]

I can't seem to get the formula to work, it wont accept the formula at all. Tried with a random formula to activate array and that worked.

[newdoverman]

bebo021999's formula works just fine. It has to be Array Entered in order to work. You may have to change the commas (,) to semicolons ( ; ) depending on the regional settings of your computer.

This is a shortened version of bebo021999's formula...Array Enter with Ctrl + Shift + Enter

Please Login or Register  to view this content.

[pagsju]

Thank you all for the help! it was the commas. Changed it for semicolon.

Cheers people!