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.

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.

Try this array formula**:

=SUM(--(FREQUENCY(IF(rng=0.25,COLUMN(rng)),IF(rng<0.25,C OLUMN(rng)))=2))

This will only count when there are *2* consecutive instances. If you have:

..25, .25, .25,.87, .25, .98, .25, .25

The result will be 1.

If you have:

..25, .25, .25,.87, .25, .25, .25, .25

The result will be 0.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Thanks a lot Ralph. it worked."
wrote in message
...
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.

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.

this formula shows how many times .25 occurs. I want to know how many times
it occurs two days in a row.

"Teethless mama" wrote:

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.

How do i enter this formula? When I put it in a cell it does not act like a
formula.
what is "rng" and "column(rng)?

"T. Valko" wrote:

Try this array formula**:

=SUM(--(FREQUENCY(IF(rng=0.25,COLUMN(rng)),IF(rng<0.25,C OLUMN(rng)))=2))

This will only count when there are *2* consecutive instances. If you have:

..25, .25, .25,.87, .25, .98, .25, .25

The result will be 1.

If you have:

..25, .25, .25,.87, .25, .25, .25, .25

The result will be 0.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Thanks a lot Ralph. it worked."
wrote in message
...
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.

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.

rng is your actual range of cells. Like A1:J1 or whatever. I assumed your
range was in a row since that's how you posted it. If your actual range is
in a column replace every instance of COLUMN in the formula with ROW.

Enter the formula as an array. That is, type the formula then use the key
combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL
key and the SHIFT key then hit ENTER.

Biff

"Thanks a lot Ralph. it worked."
wrote in message
...
How do i enter this formula? When I put it in a cell it does not act like
a
formula.
what is "rng" and "column(rng)?

"T. Valko" wrote:

Try this array formula**:

=SUM(--(FREQUENCY(IF(rng=0.25,COLUMN(rng)),IF(rng<0.25,C OLUMN(rng)))=2))

This will only count when there are *2* consecutive instances. If you
have:

..25, .25, .25,.87, .25, .98, .25, .25

The result will be 1.

If you have:

..25, .25, .25,.87, .25, .25, .25, .25

The result will be 0.

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Biff

"Thanks a lot Ralph. it worked."
wrote in message
...
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.

My formula does exactly what you want. Have you try it out?


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

this formula shows how many times .25 occurs. I want to know how many times
it occurs two days in a row.

"Teethless mama" wrote:

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.

My formula does exactly what you want.

No it doesn't.

Try it on this data:

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

Depending on what the OP wants the result should be either 2 or 0. Your
formula returns 3.

Biff

"Teethless mama" wrote in message
...
My formula does exactly what you want. Have you try it out?


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

this formula shows how many times .25 occurs. I want to know how many
times
it occurs two days in a row.

"Teethless mama" wrote:

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.

How do I write the formula to work accross columns like a1:m1

"Teethless mama" wrote:

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.