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 O’Reilly online learning.

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