Counting with COUNTIF

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

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

Flashcards are hidden until you start studying

More Like This

Use Quizgecko on...
Browser
Browser