Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers

Let's say that for 100 cells down column B, you have a dozen varieties of olives listed, some of them appearing multiple times. How can you use the COUNTIF function to find the number of times the Greek variety is listed?

=COUNTIF(B5:B105, "greek")
=COUNTIF(B5:B105, "greek", SUM(B5:B105))
=COUNTIF("greek",B5:B105, SUM(B5:B105))
=COUNTIF(B5:B105, greek, SUM(B5:B105))
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon