Chapter 20. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions

Questions answered in this chapter:

  • Suppose I have a list of songs that were played on the radio. For each song, I know the singer, the date the song was played, and the length of the song. How can I answer questions such as these about the songs in the list:

    • How many were sung by each singer?

    • How many were not sung by my favorite singer?

    • How many were at least four minutes long?

    • How many were longer than the average length of all songs on the list?

    • How many were sung by singers whose last names begin with S?

    • How many were sung by singers whose last names contain exactly six letters?

    • How many were played after June 15, 2005?

    • How many were played before 2009?

    • How many were exactly ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.