Skip to content

This site uses cookies to store information on your computer. Some are essential to make our site work; others help us improve the user experience. By using the site, you consent to the placement of these cookies. Read our privacy policy to learn more.

Close
AICPA-CIMA
  • AICPA & CIMA:
  • Home
  • CPE & Learning
  • My Account
Journal of Accountancy
  • TECH & AI
    • All articles
    • Artificial Intelligence (AI)
    • Microsoft Excel
    • Information Security & Privacy

    Latest Stories

    • Reputation, security, compliance: Why AI risk disclosures are surging
    • AICPA releases gen AI tool: Josi
    • AI-driven spreadsheet tools — what CPAs need to know
  • TAX
    • All articles
    • Corporations
    • Employee benefits
    • Individuals
    • IRS procedure

    Latest Stories

    • From childhood tax surprise to CPA: A profession leader’s journey
    • Social Security wage base and COLA announced for 2026
    • Congress passes bill requiring IRS to clarify math error notices
  • PRACTICE MANAGEMENT
    • All articles
    • Diversity, equity & inclusion
    • Human capital
    • Firm operations
    • Practice growth & client service

    Latest Stories

    • Reputation, security, compliance: Why AI risk disclosures are surging
    • From childhood tax surprise to CPA: A profession leader’s journey
    • AICPA releases gen AI tool: Josi
  • FINANCIAL REPORTING
    • All articles
    • FASB reporting
    • IFRS
    • Private company reporting
    • SEC compliance and reporting

    Latest Stories

    • SEC accepting Professional Accounting Fellow applications
    • SEC names new chief accountant
    • SEC ends legal defense of its climate rules
  • AUDIT
    • All articles
    • Attestation
    • Audit
    • Compilation and review
    • Peer review
    • Quality Management

    Latest Stories

    • Right-size your quality management documentation for SQMS No. 1
    • PCAOB publishes guidance related to Audit Evidence amendments
    • AICPA unveils new QM resources to help firms meet Dec. 15 deadline
  • MANAGEMENT ACCOUNTING
    • All articles
    • Business planning
    • Human resources
    • Risk management
    • Strategy

    Latest Stories

    • Promotion opportunities abound for CFO hopefuls
    • Business outlook brightens somewhat despite trade, inflation concerns
    • AICPA & CIMA Business Resilience Toolkit — levers for action
  • Home
  • News
  • Magazine
  • Podcast
  • Topics
Advertisement
  1. newsletter
  2. Extra Credit
Extra Credit Cover

How Excel COUNTIF function saves time when analyzing final grades

By Wendy Tietz, CPA, Ph.D.; Jennifer Cainas, CPA, DBA; and Tracie Miller-Nobles, CPA
September 14, 2021

Please note: This item is from our archives and was published in 2021. It is provided for historical reference. The content may be out of date and links may no longer function.

Related

May 11, 2021

Format column headings in Excel to make them easier to read

February 9, 2021

Various ways to display formulas in Excel

TOPICS

  • Technology
    • Microsoft Excel
  • Accounting Education

When analyzing grades (especially for a large class) the COUNTIF function in Excel can be extremely helpful.

For example, suppose you have entered your final letter grades, and you need to report how many students have earned a certain letter grade. You can easily determine this using the COUNTIF formula.

COUNTIF will count how many items (letters, numbers, or words) within the range you select meet the search criteria you set. Say, for example, you want to know how many students earned a final grade of F in your class, as illustrated in the example below. Begin by typing =COUNTIF( in an empty cell, followed by the range you want to search (C2:C18 in the example below) and the cell that contains that criteria you want to search for (D4 in the example below), and press Enter. (If you prefer, rather than typing the cell names in the formula, left-click on the start of the range and hold and drag to the end, type in a comma, click on the cell with the criteria, type in a close parenthesis, and press Enter.)

countif1


You will then see the total number of the criterion you searched for. In this example, we see the number 3, indicating that three students received a grade of F.

countif2


You can also manually input the range directly into the COUNTIF formula in the cell’s text input bar by placing it in quotation marks. In this example, for instance, you would type the formula COUNTIF(C2:C:18,“F”).

However, in this case, rather than specifying that the criteria was “F” within the COUNTIF formula, we had the formula reference the highlighted cell (D4) instead. When you use COUNTIF this way, you can easily change the letter grade and the count will automatically update, without needing to alter the formula. For example, if you now want to know how many students earned an A, you only need to change the letter grade in the highlighted cell and press Enter. The count automatically updates, as you can see in the screenshot below:

countif3


Although this technique might not seem as helpful with small amounts of data, using it with larger class sizes can be a huge time saver!

Advertisement

— Wendy Tietz, CPA, CGMA, Ph.D., is a professor of accounting at Kent State University in Kent, Ohio; Jennifer Cainas, CPA, DBA, is an instructor of accountancy at the University of South Florida in Tampa; and Tracie Miller-Nobles, CPA, is an associate professor of accounting at Austin Community College in Austin, Texas. See their site AccountingIsAnalytics.com for resources they have developed for teaching data analytics in introductory accounting. To comment on this article or to suggest an idea for another article, contact senior editor Courtney Vien at Courtney.Vien@aicpa-cima.com.

Advertisement

latest news

October 29, 2025

Reputation, security, compliance: Why AI risk disclosures are surging

October 28, 2025

From childhood tax surprise to CPA: A profession leader’s journey

October 27, 2025

AICPA releases gen AI tool: Josi

October 27, 2025

The accounting graduate pipeline: Where do things stand?

October 24, 2025

Social Security wage base and COLA announced for 2026

Advertisement

Most Read

Why accountants need to master the art of reading the room
IRS furloughs nearly half its workers, closes most operations
Using 3 Excel View tools to manage large spreadsheets
Annual inflation adjustments announced for tax year 2026
Social Security wage base and COLA announced for 2026
Advertisement

Podcast

October 30, 2025

3 types of difficult people — and how to work better with them

October 23, 2025

Reflecting on AI’s rise in accounting, looking to what comes next

October 16, 2025

AI, succession, the talent pipeline, and defining ‘unapologetic’ ambition

Features

AI-powered hacking in accounting: ‘No one is safe’
AI-powered hacking in accounting: ‘No one is safe’

AI-powered hacking in accounting: ‘No one is safe’

Building a better firm: How to pick the proper technology
Building a better firm: How to pick the proper technology

Building a better firm: How to pick the proper technology

Why accountants need to master the art of reading the room
Why accountants need to master the art of reading the room

Why accountants need to master the art of reading the room

How BI and analytics enhance management accountants’ partnering role
How BI and analytics enhance management accountants’ partnering role

How BI and analytics enhance management accountants’ partnering role

SPONSORED REPORT

Preparing clients for new provisions next tax season

Preparing clients for new provisions next tax season

As the 2025 filing season approaches, H.R. 1 introduces significant tax reforms that CPAs must be prepared to navigate. These legislative changes represent some of the most comprehensive tax updates in recent years, affecting both individual and corporate taxpayers. This report provides in-depth analysis and guidance on H.R. 1.

From The Tax Adviser

September 30, 2025

Current developments in taxation of individuals: Part 1

August 30, 2025

2025 tax software survey

August 30, 2025

Are you doing all you can to keep the cash method for your clients?

July 31, 2025

Current developments in S corporations

MAGAZINE

October 2025

October 2025

October 2025
September 2025

September 2025

September 2025
August 2025

August 2025

August 2025
July 2025

July 2025

July 2025
June 2025

June 2025

June 2025
May 2025

May 2025

May 2025
April 2025

April 2025

April 2025
March 2025

March 2025

March 2025
February 2025

February 2025

February 2025
January 2025

January 2025

January 2025
December 2024

December 2024

December 2024
November 2024

November 2024

November 2024
view all

View All

http://JofA_Default_Mag_cover_small_official_blue

PUSH NOTIFICATIONS

Learn about important news

This quick guide walks you through the process of enabling and troubleshooting push notifications from the JofA on your computer or phone.

CPA LETTER DAILY EMAIL

CPA Letter Logo

Subscribe to the daily CPA Letter

Stay on top of the biggest news affecting the profession every business day. Follow this link to your marketing preferences on aicpa-cima.com to subscribe. If you don't already have an aicpa-cima.com account, create one for free and then navigate to your marketing preferences.

Connect

  • X Logo JofA on X
  • facebook JofA on Facebook

HOME

  • News
  • Monthly issues
  • Podcast
  • A&A Focus
  • PFP Digest
  • Academic Update
  • Topics
  • RSS feed rss feed
  • Site map

ABOUT

  • Contact us
  • Advertise
  • Submit an article
  • Editorial calendar
  • Privacy policy
  • Terms & conditions

SUBSCRIBE

  • Academic Update
  • CPE Express

AICPA & CIMA SITES

  • AICPA-CIMA.com
  • Global Engagement Center
  • Financial Management (FM)
  • The Tax Adviser
  • AICPA Insights
  • Global Career Hub
AICPA & CIMA

© 2025 Association of International Certified Professional Accountants. All rights reserved.

Reliable. Resourceful. Respected.