Chapter 19. The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions

Suppose I have a list of songs that are 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

  • How many songs were sung by each singer?

  • How many songs were not sung by Eminem?

  • How many songs lasted at least 4 minutes?

  • How many songs were longer than average?

  • How many songs were sung by a singer whose last name begins with S?

  • How many songs were sung by a singer whose last name contains six letters?

  • How many songs were sung after June 15, 2005?

  • How many songs were sung before the beginning of 2009?

  • How many songs lasted exactly 4 minutes?

In a more general context, how do I perform operations such as ...

Get Microsoft® Excel Data Analysis and Business Modeling now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.