Podcast
Questions and Answers
Which function can be used to count the number of cells that meet a specific criterion?
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?
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?
How can you count cells that are not blank using a function?
- SUM
- COUNT
- COUNTA (correct)
- COUNTIF