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.