A B
1 Bob 3
2 Bob 10
3 Sue 10

7 8-13 13-20
Bob 1 1 0
Sue 0 1 0
Jeff 0 0 0

Based on the first table, I would like a formula in the second table that
calculates how many of their numbers fall into the specific categories of 7,
8-13, etc.

THANK YOU