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")
Bookmarks