O'Reilly logo

Microsoft® Excel Data Analysis and Business Modeling by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required