I mean: That sum would be your count of rows for which the value in column A
is one more than the value in column B.

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Dave F" wrote:

I would create a helper column, say in Column C, with the following formula:
=IF(A1=B1+5,1,0) and fill that down, then sum column C. That sum would be
your count of rows for which the value in column A is one more than the value
in column C.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Sandy" wrote:

I have two ranges A1:A100, B1:B100 each containing single digit numbers
typically between 3 and 8. (No blank cells.
I would like to count all the instances of each time row B contains a number
one less than that in the equivalent A cell. eg if A5 contains 6 and B5
contains 5 then that would count as one instance. The pairs have to be the
same numbers. further eg A10 containing 6 and B10 containing 5 would count
as a second instance but A12 containing 7 and B12 containing 6 would not. Am
I making sense?
TIA
Sandy