Hi! I've got this thing that I really can't figure out, and it would be a big help if someone could give me advice.

I want to count the times that a value in one column has a value of one greater than the value of the corresponding cell in another column. (For example, A1=1 and B1=2, A2=1 and B2=2, etc.) I've tried =COUNTIFS(A1:A180, (B1:B180)+1) and =COUNTIFS(A1:A180, "="&(B1:B180)+1) with no luck. (It gives me a value of zero, but I can tell just by looking at the numbers that there should be at least a few times when this event occurs.)

Could someone suggest a way to do this, or let me know if it's even possible? Thank you very much!