Does anyone have any suggestions on how to apply countif?
=Countif(Range, Criteria)
There is a table C1:Z100, and there is a list of number under column A1:A100

There is a given number 3 in cell A200, I would like to apply countif
function under the column B in order to find out how many numbers under the
table match the number under column A1:A100 with error range 3, which is
given in cell A200.
The error range means that 1 under column A is match 3 within the table
C1:Z100, because 3-1=2, which is within the error range 3, then I consider 3
is matching the number 1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric