Count variable values with conditions

Hello! Been trying to get this but don't know how... Could you help?

I attach a image on how data is arranged:
Captura de pantalla 2022-02-24 092518.png


What data do I have?

In the table "A1:C3" I have minimum (MIN) and maximum (MAX) ranges for the X and Y axis (the ranges are variable).

For each value of "F:F"; there is a variable number of coordinates (X,Y), it goes in two columns in block ("G1:H1")("I1:J1")("K1:L1")... the number of coordinates is variable in each case.

Currently I know how to calculate for the whole row "G2:BB2" the X and Y values that are within the range (MIN-MAX). The problem I have is that I don't know how to differentiate by blocks, it counts ALL values without conditioning.
Ideally, it should count the values in the case that the block of "G2" and "H2" are within the ranges defined in the table "A1:C3", and then jump to the next block "I2" and "J2" ... once the row is finished, jump to the next value of "F:F".



As far as I understand to condition this with formulas is not possible, so my question is:

Is it possible to automate it with VBA in column "E:E" starting with "E2"?

Many Thanks!

The following function might work for you. In the VB Editor, insert a new module (if you don't already have one), then paste this code:

Please Login or Register  to view this content.

In E2 you can then put the following formula and fill down:

Formula:

Please Login or Register  to view this content.

Adjust your range references to suit your specific needs.