For the numbers in column F I’m trying to get a count of the number of times that the numbers appear between the ranges in columns C to D. The total would increment in column E as these numbers were found in the range.

Example: The numbers 60 (F2) and 150 (F3) would appear in the range 1 (C1) to 156 (D1). The count would be 2 which would appear in cell E1.

Any help to come up with a formula would be greatly appreciated. If it is easier to do as a macro then I would accept that code also. Thanking You in advance.

**Important Notice**

We will be implementing some important changes during 25th and 26th May 2024 which may result in an outage period of the website. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!