[Solved] Consecutive counting

[runnerhiker]

I have a large data base composed in horizontal rows as five variables p, 8, b, d, t.

I wish to count the consecutive times a variable does not occur?

These are the requirements:
1.) If P or 8 count +1
2.) If b NO count.
3.) If d or t count remains as the preceding cell count.

Don

[RusselB]

Your statement on the 2nd line of your post seems, to me, to contradict (in part, but not totally) what you have posted as your requirements.
For what you ask for in the 2nd line, Do a total count (I suggest using COUNTA), then subtract the count of the variable (obtained using COUNTIF)

If what you want is better described in your requirements, then I suggest using COUNTIFS.
Note: COUNTIFS is not in the Help file, but does have a balloon pop-up help when being entered.

[runnerhiker]

Thanks for the help in developing a consecutive counting algorithm. It gave me some new ideas and I now have a successful algorithm for counting my data base of Baccarat.

Don