Running total of consecutive numbers

[janderson055]

I am trying to put together a formula that will count the consecutive "100"s in a row and return that number. For example if the row shows:
95 100 90 100 100 = 2
But I also want it to start over if the last entry isn't 100, i.e.;
95 100 90 100 100 90 = 0

Anybody have a good idea of how I can keep this running total?
Thanks.

 

[shg]

      -A-- --B--
  1   Data Count
  2     95     0
  3    100     1
  4     90     0
  5    100     1
  6    100     2

In B2 and copied down,

=IF(A2<>100, 0, SUM(B1, 1))

 

[janderson055]

I have my data in rows instead of columns and can't change it at this point. Also is there a way I can have a running total just in one cell? Instead of having the total in each B column, just have one cell that will count the consecutive values and revert back to 0 once a value other than 100 is entered?

 

[janderson055]

Forgot the part about having my data in rows, I figured that out and have your function working with my data. I still need to find a way to just have the running total in one cell, where it updates with each new value I enter, resetting the count if a number other than 100 is entered.