UNIX for Beginners Questions & Answers

awk '{SUM[$1 OFS int($2/100)*100] += $4} END {for (s in SUM) print s, SUM[s]}' OFS="\t" file1 | sort
N1	0	2
N1	100	2
N1	300	0
N1	400	3
N1	500	1
N1	600	0
N1	700	1
N2	0	0
N2	500	4
N2	600	5
N2	700	6

awk '
FNR == 1        {next
                }
NR == FNR       {SUM[$1 OFS $2 OFS $3]
                }
                {for (s in SUM) {split (s, T, OFS)
                                 if ($1 == T[1] &&
                                     $2 >= T[2] &&
                                     $2 <= T[3]) SUM[s] += $4
                                }
                }
END             {for (s in SUM)  print s, SUM[s]     # {split (s, T, OFS) redundant, I think
                                                     #}
                }
' OFS="\t" file2 file1 | sort
N1    0    99    2
N1    100    199    2
N1    200    299    0
N1    300    399    0
N1    400    499    3
N1    500    599    1
N1    600    699    0
N1    700    799    1
N1    800    899    0
N1    900    999    0
N2    0    99    0
N2    100    199    0
N2    200    299    0
N2    300    399    0
N2    400    499    0
N2    500    599    4
N2    600    699    5
N2    700    799    6
N2    800    899    0
N2    900    999    0

expected result:
N1    600    699    1   
N1    700    799    0   
N1    800    899    0   
N1    900    999    0

file1.table
N1 752 875  1

SUM[$1 OFS int($2/100)*100]     #A very good trick to me for simple situations
...
for (s in SUM) {split (s, T, OFS) 
    if ($1 == T[1] && $2 >= T[2] && $2 <= T[3]) 
          SUM[s] += $4