easy5 pts · first answer countsexcelconditional-functions

Counting orders above ₹50,000

Order values are in C2:C500. Which formula counts orders greater than 50,000?

A.=COUNTIF(C2:C500,">50000")B.=COUNTIF(C2:C500,>50000)C.=COUNT(C2:C500>50000)D.=COUNTIF(">50000",C2:C500)

Discussion 0

Join free to post in the discussion.