Question

plz guys Find how many items with cheaper than 100.
Write formula for solving this using ms excel

Answer 1

Answer:

Use of COUNTIF function

Explanation:

Use countif function:

• COUNTIF(range of cells, "condition you want")

See the screenshot below

( continuation from previous question)