View Single Post
  #9   Report Post  
VitaliyK VitaliyK is offline
Junior Member
 
Posts: 1
Default

What whould be a proper way to make a formula sum a total of pass/ fail results.
Let say i have Total Pass: on C2
and line of pass/fail on b14:b573
Thank you


Quote:
Originally Posted by Nadine View Post
Need help with a formula.

Want to sum the total of a range of cells, then if it is less then a
specific number the value should be "Fail", if greater then that number then
value should be "Pass"

I've used the And function True or False results. But they want the value
in the cells to say either Pass or Fail.

current formula: =AND(SUM(J8:R8)0,SUM(J8:R8)<8)

Thanks