Hi,

I have two columns of data and I want to count using a single formula the number of times the value in the first column is larger than the adjacent value in the second column. I have tried the following array which returns an error:

{=countif(a1:a1000-b1:b1000,"<0")}

Can someone please suggest how I can do this correctly.

Thanks!