Hello Smith,

In the formula some parentheses are missing also should be =A9 NOT ,A9. try this

=SUMPRODUCT(('Tech Level'!$A$2:$A$2000=A9)*('Tech Level'!$BE$2:$BE$2000>=21)*('Tech Level'!$BE$2:$BE$2000<=24))

Since you are on Excel 2007, better to use COUNTIFS.

=COUNTIFS('Tech Level'!$A$2:$A$2000,A9,'Tech Level'!$BE$2:$BE$2000,">=21",'Tech Level'!$BE$2:$BE$2000,"<=24")