HELP! I'm trying to calculate the value on a row and % under 50%

So for instance Multiple reps on a sheet (100) and how many Reps finished under 50% to Target for the month.  3 columns (Date, Rep name and % to target).  I've tried: =COUNTIF('SOW (New)'!B2:B836,"J...