I would like .25 .25 .99 .66 .25 .55 .25 .25 to show equals 2. thats how many
times .25 happens in a row

"T. Valko" wrote:

I don't know if they want to count when there are more than 2 consecutive
instances but just FTHOI try your formula on this data:

..25, .25, .25, .25, .33, .66

The formula returns the correct result but it's probably not what you'd
expect!

Biff

"Teethless mama" wrote in message
...
Try this:

=SUMPRODUCT(--(A1:A99=0.25),--(A2:A100=0.25))


"Thanks a lot Ralph. it worked." wrote:

I have a thirty day worksheet with numbers entered each day form .1 to
.99.
Is there any way to calulate how many times .25 was entered two days in a
row.
example .25 .25 .10 .87 .25 .98 .25 .25 , in this case it would be two
times.