Counting with COUNTIF
3 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which function can be used to count the number of cells that meet a specific criterion?

  • COUNTIF (correct)
  • AVERAGEIF
  • SUMIF
  • MAXIF

    • What is the syntax of the COUNTIF function?

  • =COUNTIF(What do you want to look for., Where do you want to look.)
  • =COUNTIF(Where do you want to look., What do you want to look for.) (correct)
  • =COUNTIF(Where do you want to look.)
  • =COUNTIF(What do you want to look for.)

    • How can you count cells that are not blank using a function?

  • SUM
  • COUNT
  • COUNTA (correct)
  • COUNTIF

    • More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser