Forum Discussion
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...
I agree with Hans in not understanding why you have "Joe Bloggs" as part of the COUNTIF. If you want total number of lines showing <50% then try:
=COUNTIF('SOW (New)'!N2:N715,"<"&50%)