How to count cells in Excel?

If you are a staff of a company or mini store or somewhat like that, you need to work with Microsoft Excel. Probably, you insert several values and numbers of products sells or numbers of a survey. It’s very hard to determine a specific series of cells. There is a simple way to count number of cells automatically. In fact, we show how to count cells in Excel automatically. We use Microsoft Excel 2016 version.

A simple way to count cells in Excel automatically

Follow below steps to count cells in Microsoft Excel.

Step1: Select the cells you want to count.

How to count cells in Excel?

Step2: Go to Home tab. Then, look for Editing box.

How to count cells in Excel?

Click on AutoSum. Choose Count Numbers from the drop-down list.

How to count cells in Excel?

It counts all selected cells automatically and shows the result at the end of selected cells.

How to count cells in Excel?

Determine Max or Min of the cells values

Also, you can determine the Max or Min of several numbers simply. The same as previous steps, first select the cells you want to average. Then, go to Home—> Editing—> AutoSum—> Max. It shows you the maximum number of selected cells values.

How to count cells in Excel?

As the same way you can determine minimum of the cells values.

Comment on How to count cells in Excel tutorial if you know easier ways to make it better.

How to count cells in Excel?
3.8 (75.45%) 22 votes

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *