=SUMPRODUCT(--(A1:A100="Bob"),--(B1:B1007))

=SUMPRODUCT(--(A1:A100="Bob"),--(B1:B100=8),--(B1:B100<=13))


"TMF in MN" wrote:

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