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

Question

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,"Joe Bloggs")+(COUNTIF('SOW (New)'!N2:N715,""<50%))

But this just counts the total % and seems to ignore <50%

Any Suggestions?

hansvogelaar · Answer

What has Joe Bloggs to do with it?

ratcliffe2020 · Answer

Joe Bloggs is an example rep name... I have 10 Reps in total

hansvogelaar · Answer

But why do you have a COUNTIF for Joe Bloggs?

m_tarler · Answer

I agree with Hans in not understanding why you have "Joe Bloggs" as part of the COUNTIF.&nbsp; If you want total number of lines showing &lt;50% then try:=COUNTIF('SOW (New)'!N2:N715,"&lt;"&amp;50%)

Forum Discussion

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

Resources