Need formula to count cells below

[bill_s1416]

Column E on my spreadsheet contains a series of values TRUE and FALSE in no particular order (they are the results of a formula, the details of which I won't bore anybody with.) I need a formula in column F that checks if the corresponding cell in column E contains "TRUE" and if so, it counts the number of "TRUE's" below it before the next occurrence "FALSE."

[AlfD]

Hi!

You could do this with a VBA routine.

If you are not working dynamically but have a static situation, you could probably get what you want by using Data > Subtotals operating on the changes in the column with True and False and counting the number in each section. (And contrary to all the usual advice on subtotals, DO NOT SORT before you do it !!!)

Alf