Working with 2 linked spreadsheets
Sheet 1 contains a range of 20 cells each containing golf scores from last 20 rounds of a single golfer.
Sheet 2 contains a cell that represents the golfers "Target Score For Shooting Handicap" (ie 88.30 which is based on a combination of the golfers handicap index and the course rating) this number is in a cell for reference in the CountIF formula.

I am trying (unsuccessfully) to calculate the number of times an individual golfer had scores (from the range of 20 rounds) that was within +3 or -3 of the "Target Score For Shooting Handicap" (ie 88.30).

The formula Im using keeps resulting in a "0" even thought there are several rounds in the range of 20 that are within the criteria.

Any insight is appreciated. Thx Bob