Sumif not working as wanted

[Apples52]

See highlighted cell D2 for my sumif formula. What I want to do is sum the row Q:AK if the description in colum F matches the description in cell B2 (Outside Sales). There are 3 Outside Sales in column F, but the formula only appears to be adding the first two rows, as 6,914.80 + 6,914.80 = 13,829.60. I can't get it to add that thrid row.

Q is the only column with earnings for Outside Sales in this instance.

Where am I going wrong?

 

[Phuoc]

Try this:

=SUM(FILTER($Q:$AK,$F:$F=B2,""))

 

[Scott Huish]

Perhaps:
=SUMPRODUCT((F2:F1000=B2)*Q2:AK1000)

 

[Apples52]

Both of these worked. Thanks so much!