WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Count Values in Excel

February 13, 2023
9.8K Views

When you are working in excel Excel/Spreadsheet WPS, you need to find how many times a value/number occurs in different range of cells in rows or column. Excel provide different methods and tools to count values in excel  in any cell for analysis or any other purpose  Most people get confused and found very difficult to how to count values in excel spreadsheet.

However Using WPS excel/spreadsheet is very simple and helpful only if you know the right steps and methods. This article will help you to understand the steps involves how to count values in excel/spreadsheet WPS and after reading the article you can easily perform this task in your WPS excel/spreadsheets (2016/2019/mac/online). Followings are the simple steps to be followed to easily understand this task,

Different ways to Count values in Excel Spreadsheet (2016/2019/Mac/Online)

How to count values in cell using count Formula

1.Go to WPS office and click on excel Spreadsheet

2.Select range of cells in a column or row in which you want to count the values Select the cell in your excel spreadsheet where you want to count the values and write = sign thereThen write ‘’ COUNT’’ command in that cell as =COUNT

3.Then click on first value of the cell of your excel spreadsheet and drag down to the last value of cell you want to count

4.After selecting the values press ENTERAfter pressing the ENTER, The count of values will be shown in that cell

.

How to count values in cell using Auto Sum

1.Go to WPS office and click on excel Spreadsheet

2.Select the range of cells in column or row in your excel spreadsheet you want to count and write = sign there.

3.Then Go to the formula Tab and Click on the AutoSum.

4.When you click on Autosum a table will be displayed.

5.In table click on Count Function and write the range of cells you want to count in your excel spreadsheet.

6.In this sheet the range of cells is C6:C12.

7.After writing the range of cells press the ENTER and the count value will be shown in that cell.

How to count values in cell using Subtotal Function

1.Go to WPS office and click on excel SpreadsheetGo to the cell where you want to count the valuePress = in that cell and write “SUBTOTAL”

2.After you write Subtotal a table will be displayed with different function.

3.Click on the “COUNT” function

4.Now write the range of the cells in Column or row you want to count. 

5.The range of values to be counted in our excel spread sheet is from C6-C12.

6.After writing the range of cells, press ENTER and the count value will be shown in that cell.

7.The function of subtotal to count values will be written as =SUBTOTAL(2,C6:C12)

This article has covered the methods on How to count values in excel/spreadsheet WPS (2016/2019/Mac/Online),You can use these simple steps as explained above and easily count values in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.

Hopefully, you have learned How to count values in WPS Excel/Spreasheet (2016/2019/Mac/Online) by following the above steps.  If you want to know more about Word features, you can follow WPS Academy to learn. You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.