Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Reviewing Formulas and Functions Part 3: COUNT in Excel

March 2, 2023 by Madeleine Moucheron

Most working professionals want to save time when writing reports and copying data into spreadsheets, yet worrying about making mistakes can slow progress to a crawl. If you want to save time and make sure you’re recording accurate data, mastering a few Excel formulas is worth your effort.

Read on to learn about the COUNT formula and how it can help you at work.

COUNT in Excel

Instead of manually counting the number of cells being used in an Excel spreadsheet, the COUNT function can provide you with a quick, accurate answer.

Using the COUNT Formula

To use the COUNT function, there are two options, and each one depends on what you’re trying to count. Counting the cells that contain numeric values can be done this way:

  • =COUNT(C4:C9) – this will provide you with the number of cells in this sequence that have numbers in them (if all of them do, the answer is 6)

Counting the cells that simply aren’t blank (as in, they can have numbers, letters, or symbols in them), you would use this formula:

  • =COUNTA(C4:C9) – if 3 cells contain numbers, one contains letters, and two are blank, the value you would get is 4)

If you’d like to learn more Excel formulas that can make your job easier, quicker, and more accurate, stay tuned. We’ll steadily release an Excel series in the form of several short, simple blog posts.

We at Learn Excel Now hope you feel comfortable creating using the SUM, AVERAGE, and COUNT functions in Excel.

Like Learn Excel Now? Follow us on social media and share our content with your networks!

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In