Search for:
Quick Category Links

SharePoint
Project Management
Professional Development
Office Applications
Categories
Tags
AJAX briefing Business Certification Conferences Consulting CorasWorks Document Management Education and Training Email Enterprise Project Management EPM Events Excel Knowledge Management Maintenance Meta element Microsoft Microsoft Access Microsoft Excel Microsoft Office Microsoft Outlook Microsoft PowerPoint Microsoft Project Microsoft SharePoint Microsoft SharePoint Designer Microsoft Windows Microsoft Word Mondosoft Office 2007 Ontolica Operating Systems PMI PMP PowerPoint Project Management SDPS search seminar SEO SharePoint Designer Social Media Twitter Windows Server 2008 Windows Vista
Other Links
Blog Network:
Name:
Springhouse Blog :: Our Knowledge = Your Learning
Topics:
technology, sharepoint
Join my network
Blog Networks

Meet Our Authors

Nov

Using Excel’s COUNT and COUNTA Function to Return Number of Records

By Jane H (25 posts -- read other by posts Jane H)

Sooner or later you will need to know how many items are within a range of cells. If you try to count them by hand, it will be difficult and time-consuming. For example, imagine trying to count the items in a range consisting of 200 cells. Excel provides different functions that you can use to do such tasks.

The COUNT function

Counts the number of cells that contain numbers, dates, and text formatted numbers within the list of arguments. Use COUNT to get the number of entries in a number field that is in a range or array of numbers. It has the following structure, where Value1, value2, … are 1 to 255 arguments that can contain/refer to a variety of data types:

= COUNT(value1,value2,…)

For example, the function =COUNT(A1:A8) calculates the number of cells in the range that have either a numeric value, a date value, or a text representation of a number. Consider the data in the sample to the right.

In the sample, the resulting value that is returned by the COUNT function is 3, because 3 cells have either numbers or date values. It does not count empty cells or cells with text.

The COUNTA function

Counts the number of cells that are not empty. Use COUNTA to get the number of entries in a range or array of numbers. It has the following structure, where Value1, value2, … are 1 to 255 arguments that can contain/refer to a variety of values types:

= COUNTA(value1,value2,…)

For example, the function =COUNTA(A1:A8) calculates the number of cells in the range that have any value, including a space. Consider the data in the sample to the right.

In the sample, the reslting value that is returned by the COUNTA function is 6, because 6 cells have values. It does not count empty or blank cells.

Technorati Tags: Excel, Microsoft Excel

Related Posts:

Filed Under Excel |