How to Sum/Count/Average Visible Cells, Rows, Columns in Excel?
Tags: kutoolsexceltutorial, sumorcountoraveragev, kutools
Published: 2020-09-14 10:01:02

---
title: How to Sum/Count/Average Visible Cells, Rows, Columns in Excel?
published: true
date: 2020-09-14 07:00:31 UTC
tags: KutoolsExcelTutorial,SumorCountorAverageV,Kutools
canonical_url: https://geekexcel.com/how-to-sum-count-average-visible-cells-rows-columns-in-excel/
---

## Sum/Count/Average Visible Cells, Rows, Columns in Excel:

In this post, we are going to explore how to **Sum/Count/Average Visible Cells, Rows, Columns in Excel Office 365** using **Kutools**. Let’s get started!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task easily. If you want to use Kutools, you need to install it from Excel’s official website.

## Sum Visible Cells, Rows, or Columns Only:

If you want to sum visible cells, rows, or columns in the Excel spreadsheet, do the steps as follows.

- Let’s learn this with a given example. You can see the **Visible Columns A, B, D, F, and Column C, E are [hidden](https://geekexcel.com/simple-shortcut-to-hide-columns-in-microsoft-excel-365/)**. You can also see the **[hidden rows](https://geekexcel.com/quick-keyboard-shortcut-to-hide-rows-in-ms-excel-365/) 2, 7** in the screenshot.

[![Visible Rows and Columns](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/11-1.png)](https://geekexcel.com/?attachment_id=13800#main)<figcaption id="caption-attachment-13800">Visible Rows and Columns</figcaption>

- Now, you can apply the **SUMVISIBLE**  **Function** to find the sum of the visible rows, columns, or cells.
- You need to **select** a **blank cell** where you want to display the result.
- On the **Kutools** tab, **select** the **Kutools**  **Functions** option, **choose** the **Statistical & Math** option from the drop-down menu, then **choose** the **SUMVISIBLE** option from the sub-menu.

[![Select SUMVISIBLE option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-39.png)](https://geekexcel.com/?attachment_id=13803#main)<figcaption id="caption-attachment-13803">Select SUMVISIBLE option</figcaption>

- Now, it will open the Function Arguments dialog box, you need to **select a range of visible cells** to give input to the **Reference** box. Then, **hit** the **OK** button.

[![Function Arguments dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-14.png)](https://geekexcel.com/?attachment_id=13804#main)<figcaption id="caption-attachment-13804">Function Arguments dialog box</figcaption>

- Now, you can see the sum result in the **selected cell** as shown in the below image.

[![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-8.png)](https://geekexcel.com/?attachment_id=13805#main)<figcaption id="caption-attachment-13805">Result</figcaption>

### Added Information:

- You can use the **SUMVISIBLE** formula directly in the formula bar to sum visible cells only in the selected range.
- You can also use the [**SUM function**](https://geekexcel.com/sum-function/) to find the total of all integers from the selected range.

### Syntax of SUM Function:

**=[SUM](https://geekexcel.com/sum-function/)(number\_1, number\_2,… number\_255)**

## Count Visible Cells, Rows, or Columns Only:

To count visible cells, rows, or columns in Excel, follow the below instructions.

- First, you need to **select** a **blank cell** in which you want to print the output.
- On the **Kutools** tab, **select** the **Kutools**  **Functions** option, **choose** the **Statistical & Math** option from the drop-down menu, then **choose** the **COUNTVISIBLE** option from the sub-menu.

[![Select COUNTVISIBLE option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/5-5.png)](https://geekexcel.com/?attachment_id=13810#main)<figcaption id="caption-attachment-13810">Select COUNTVISIBLE option</figcaption>

- Now, it will open the **Function Arguments**  **dialog box**.
- You need to **select the range** to count the visible cells using the **Reference** box.
- Then, **click** the **OK** button.

[![Function Arguments Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/6-3.png)](https://geekexcel.com/?attachment_id=13811#main)<figcaption id="caption-attachment-13811">Function Arguments Dialog Box</figcaption>

- Now, the result is printed in the selected cell as shown in the below screenshot.

[![Total COUNT of the visible cells](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/7-2.png)](https://geekexcel.com/?attachment_id=13812#main)<figcaption id="caption-attachment-13812">Total COUNT of the visible cells</figcaption>

- You can directly apply the **COUNTVISIBLE** formula in the formula bar to count the visible cells only in the specified range.

### Note:

- You can also use [**Excel COUNT Function**](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/) to count the number of cells that contain numbers.

### Syntax of COUNT Function:

**=[COUNT](https://geekexcel.com/how-to-use-excel-count-function-in-office-365-with-examples/)(value1, [value2],…)**

## Average Visible Cells, Rows, or Columns Only:

To calculate the average of the visible cells, rows, or columns in Excel, follow the below steps.

- You need to **select** a **blank cell** in which you want to print the output.
- On the **Kutools** tab, **select** the **Kutools**  **Functions** option, **choose** the **Statistical & Math** option from the drop-down menu, then **choose** the **AVERAGEVISIBLE** option from the sub-menu.

[![Select AVERAGEVISIBLE option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/8-1.png)](https://geekexcel.com/?attachment_id=13813#main)<figcaption id="caption-attachment-13813">Select AVERAGEVISIBLE option</figcaption>

- Now, it will open the **Function Arguments**  **dialog box**.
- You need to **select the range** to find the average of the visible cells using the **Reference** box.
- After selecting a range,  **click** the **OK** button.

[![Function Arguments Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/9-1.png)](https://geekexcel.com/?attachment_id=13814#main)<figcaption id="caption-attachment-13814">Function Arguments Dialog Box</figcaption>

- After clicking the **Ok** button, the average of the visible cells will be displayed in the selected cell as shown in the below example.

[![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/10.png)](https://geekexcel.com/?attachment_id=13815#main)<figcaption id="caption-attachment-13815">Output</figcaption>

- You can directly apply the **AVERAGEVISIBLE** formula in the formula bar to count the visible cells only in the specified range.

### Note:

- You can also use **Excel AVERAGE Function** to find the average of cells that contain numbers.

## Verdict:

In this post, you can understand how to **Sum/Count/Average Visible Cells, Rows, Columns in Excel Office 365** using **Kutools**. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Video Tutorial:

<!--[if lt IE 9]><script>document.createElement('video');</script><![endif]--><video id="video-13796-1" width="770" height="410" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/record-1.mp4?_=1"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/record-1.mp4">https://geekexcel.com/wp-content/uploads/2020/09/record-1.mp4</a></video>